Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

how to remove

Hi @MayilVahanan  @Vegar 

I have a bar chat with  dimension levelname and 4 measures  but the issue is whenever i mouse over that lables is showing  0 for other 3 levels   now i want to show only for level  1  -  whenever i mouse over on level1  same for all

dim:  levelname

exp: =count({<LevelId={1},Status={'pass'}>}User_Id)/Count(User_Id)

=count({<LevelId={2},Status={'pass'}>}User_Id)/Count(User_Id)

=count({<LevelId={3},Status={'pass'}>}User_Id)/Count(User_Id)

=count({<LevelId={4},Status={'pass'}>}User_Id)/Count(User_Id)

Labels (1)
  • bar

2 Replies
MayilVahanan

Hi @soniasweety 

If you have level name in Dimension, no need to create 4 measure, you can try like below

count({<Status={'pass'}>}User_Id)/Count(User_Id)

or

count({<Status={'pass'}>}User_Id)/Count(total User_Id)

Depends on ur requirement.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Brophy1204
Contributor
Contributor

Thanks for the information