Team Publishing data set: Calculated Metric for Verified Articles



  • Gab Guinto
    Zendesk Customer Care

    Hi Ryan,

    If you're filtering the entire report by any event date attribute, then this would filter all the metrics involved in any calculation within the query. A workaround that I can suggest is to first create a date range calculated metric to get the number of articles verified this month –

    – and then use that custom date range metric in your original metric instead.


    This way, you don't have to use a query-level filter, and the total count – ((D_COUNT(Articles verified)+D_COUNT(Articles unverified)) – of verified/unverified articles in your calculation won't be filtered by date.

    Hope this helps. Thanks Ryan!



Please sign in to leave a comment.

Powered by Zendesk