Recent searches

No recent searches

Community dataset query show 0 for null event types

image avatar

Brianne Reinhardt

Posted Jun 02, 2022

Adding this here after discussing via a support ticket. Using the Community dataset:

  1. Added Metric: COUNT (Community Events)
  2. Added Row: Community engagement event type
  3. 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.

1

2

2 comments

Date
    image avatar

    Dave Dyson

    Thanks for this feedback, Brianne!

    0

    image avatar

    Orsolya Forster

    Zendesk Product Manager

    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!

    -1

    Please sign in to leave a comment.

    Didn't find what you're looking for?

    New post