Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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 for the information