Forum Discussion

Akhila's avatar
Akhila
Cloud Apps
02-15-2022
Solved

Formula for count with filter

Hi

I am trying to get the count of Id’s based on age group division in the dashboard.

 I am using the formula Count([Id],[age filter between 20 and 40]). But I am getting the count of the Id’s of all age groups(i.e filter is not applied).Please help with correct format

dashboards & reporting
  • viswanath's avatar
    viswanath
    02-15-2022

    (Count([Id]),[age filed filter by the value between 20 and 40])

    Is this format get you the result of what you expected? 

  • Ayantek's avatar
    Ayantek
    02-15-2022

    Hi Akhila ,

    Please right-click on the dimension which is "age filed filter by value between 20 to 40" in your case and filter out which value you are looking for, attached screenshot for your reference.

    (count([Brand ID]),[Age Range1])

    Ayantek.

2 Replies

Replies have been turned off for this discussion
  • viswanath's avatar
    viswanath
    Cloud Apps
    02-15-2022

    (Count([Id]),[age filed filter by the value between 20 and 40])

    Is this format get you the result of what you expected? 

  • Ayantek's avatar
    Ayantek
    Cloud Apps
    02-15-2022

    Hi Akhila ,

    Please right-click on the dimension which is "age filed filter by value between 20 to 40" in your case and filter out which value you are looking for, attached screenshot for your reference.

    (count([Brand ID]),[Age Range1])

    Ayantek.