Skip to main content
New Idea

Add count distinct to formulas in report builder

Related products:CS Reports
reneehouse
john_apple
alison_kaprielian
jean.nairon
jessie_brainerd
+59
  • reneehouse
    reneehouse
  • john_apple
    john_apple
  • alison_kaprielian
    alison_kaprielian
  • jean.nairon
    jean.nairon
  • jessie_brainerd
    jessie_brainerd
  • ben
    ben
  • sarah_johnson
    sarah_johnson
  • link_black
    link_black
  • hitesh_sharma
  • angie_delarosa
    angie_delarosa
  • phil_kowalski
    phil_kowalski
  • katie_b
    katie_b
  • mark_gecsey
    mark_gecsey
  • melissa_davenport
    melissa_davenport
  • anthonysabato
    anthonysabato
  • asaf_alshech
    asaf_alshech
  • nadav_shemtov
    nadav_shemtov
  • christin_sambor
    christin_sambor
  • phil_hart
    phil_hart
  • cmultanen
    cmultanen
  • lane_h
    lane_h
  • andrew_biehle
    andrew_biehle
  • seth
    seth
  • lesliediephuis
    lesliediephuis
  • jeffrey_boyer
    jeffrey_boyer
  • tom_gerth
    tom_gerth
  • heather_hansen
    heather_hansen
  • pele
    pele
  • darkknight
    darkknight
  • spencer_engel
    spencer_engel
  • dan_ahrens
    dan_ahrens
  • lorena_vargas
    lorena_vargas
  • sai_ram
    sai_ram
  • denim
    denim
  • David_Fink
    David_Fink
  • veneza_viamontes
    veneza_viamontes
  • nora_soza
    nora_soza
  • lauren_s
    lauren_s
  • rbegley
    rbegley
  • amy_perrin
    amy_perrin
  • amanda_sepe
    amanda_sepe
  • sophie
    sophie
  • shiv_kumar_katiyar
    shiv_kumar_katiyar
  • jeremy_curry
    jeremy_curry
  • colleen_ayres
    colleen_ayres
  • chuen_moschetti_1466d2
    chuen_moschetti_1466d2
  • nick_cellini
    nick_cellini
  • ana_g
  • jnunes
    jnunes
  • iloukanova
    iloukanova
  • sashasoci
  • edleguizamo
    edleguizamo
  • gunjanm
    gunjanm
  • cynthiam
  • tammy_c
  • jochle
  • thomascardamone
    thomascardamone
  • robinmeijer
  • CurtisValentine
    CurtisValentine
  • lmnmegan
  • bradley
    bradley
  • Megrob15
  • Steph Costa
  • caroline.harris

  • Contributor ⭐️⭐️⭐️⭐️
  • 44 replies

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

 

0 replies

Be the first to reply!

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings