Join our Community in its new Home - The Datorama Trailblazer Community Group!
It's been an amazing 3 years coming together in this forum to collaborate, innovate, support, and inspire each other about our shared usage of Datorama. While this is not quite a goodbye, we are excited to announce that we are getting a fresh start in our new home within the Salesforce Trailblazer Community. We have a ton of fun new content planned and you may even see the revival of some of our most popular posts from the past few years.
We’ll be keeping this group around for a bit for you to peruse, but as of November 15, we will no longer be allowing new posts or comments. Be sure to join our new group at https://www.salesforce.com/success-datorama to keep the conversation going.
We can’t wait to see you there!
It's been an amazing 3 years coming together in this forum to collaborate, innovate, support, and inspire each other about our shared usage of Datorama. While this is not quite a goodbye, we are excited to announce that we are getting a fresh start in our new home within the Salesforce Trailblazer Community. We have a ton of fun new content planned and you may even see the revival of some of our most popular posts from the past few years.
We’ll be keeping this group around for a bit for you to peruse, but as of November 15, we will no longer be allowing new posts or comments. Be sure to join our new group at https://www.salesforce.com/success-datorama to keep the conversation going.
We can’t wait to see you there!
how to create metric that indicates # of times or instance where a condition is true
sparkjohanna
Chicago,ILACCOUNT_ADMIN 
in Help Center
Hi - I'm trying to create a calculated measurement that returns the # of days that impressions were greater than 0 for any given placement, campaign, creative, site, etc.
I've tried a number of different ways playing around with the granularity of the calculated measurement and the aggregation functions but can't get anything that works in a report without including "day" as a dimension in the report. And in general i find that with any of my attempts if i remove a dimension from the report it will change the result of this function. So if my report includes data at both campaign and placement level, the result will change if i remove placement name but i want this to aggregate appropriately.
Any insights would be awesome. Thanks!!
cc: @mikebarilli
I've tried a number of different ways playing around with the granularity of the calculated measurement and the aggregation functions but can't get anything that works in a report without including "day" as a dimension in the report. And in general i find that with any of my attempts if i remove a dimension from the report it will change the result of this function. So if my report includes data at both campaign and placement level, the result will change if i remove placement name but i want this to aggregate appropriately.
Any insights would be awesome. Thanks!!
cc: @mikebarilli
Comments
It sounds from your explanation that your calculated measurement is dimension only. In such cases, the calculated measurement will always return 0. In order for it to calculated correctly, please add and subtract impressions in the syntax.
+ [Impressions] - [Impressions]
Having a mapped measurement in the Query "grounds" the calculation.
Let me know if you still have trouble with the calculated measurement.