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.
Please sign in to leave a comment.