Skip to main content

Add count distinct to formulas in report builder

  • July 24, 2023
  • 0 replies
  • 23 views

Forum|alt.badge.img
  • Contributor ⭐️⭐️⭐️⭐️

I really like the calculated fields in reports, but I still cannot find them useful for the metrics we maintain. In our case, I’d like to create metrics such as CTAs/Activities per account or per CSM, and for that, I had to build a DD. 

In reports, this would have been a piece of cake if ‘count distinct’ is allowed. 

Currently, you can only count which in my case does not work as it always produces 1 (there is always 1 account for the CTA or activity it was created for).

Is ‘count distinct’ in the works for report formulas?

Thanks,

Jasmina