cancel
Showing results for 
Search instead for 
Did you mean: 

Formula for count with filter

Akhila
7 - Data Storage
7 - Data Storage

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

2 ACCEPTED SOLUTIONS

viswanath
8 - Cloud Apps
8 - Cloud Apps

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

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

View solution in original post

Ayantek
8 - Cloud Apps
8 - Cloud Apps

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.

View solution in original post

2 REPLIES 2

viswanath
8 - Cloud Apps
8 - Cloud Apps

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

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

Ayantek
8 - Cloud Apps
8 - Cloud Apps

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.