Community dataset query show 0 for null event types
Adding this here after discussing via a support ticket. Using the Community dataset:
- Added Metric: COUNT (Community Events)
- Added Row: Community engagement event type
- Added Filter: Community post created at – Month and Selected a month I knew has some results of null or zero.
The event types that are null will not display even using Results Manipulation formula: COUNT(Community events)+0.
This is especially problematic if one of the types is null regardless of filter, because then we aren't aware that that event type is even tracked until there is data for it.
My request is to make sure all event types are included in the results even if they are zero/null, otherwise it's not clear what Community event types are captured and the results are potentially inconsistent week over week.
-
Thanks for this feedback, Brianne!
-
Thanks for the feedback Brianne Reinhardt!
What you need is currently not supported by Explore, queries will return results of data that is already there. Here you can read about what values are returned for the community event type attribute, we track all these events.
I suggest to track the specific metrics, i.e. COUNT(Post views) etc, those will also return 0 results.
Cheers!
Please sign in to leave a comment.
2 Comments