Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a bar graph as shown below. The graph displays Name on X axis and Scores on Y axis. I need to display the names only if the name has value for another measure Grades that is not displayed on graph. For example John doesn't have a grade , so John should not appear on the dashboard. Help is appreciated.
You need to use something like this as your dimension:
=aggr(only({$<Grades-={*}>} Name), Name)
just wanted to know , can I use Dimension limitation - Exact value then select fx, give Sum(grades) there.
Sorry, I'm not sure what your question is. A little more detail would help.
I am talking about this. Here below instead of number if I use the function , in this case sum(grades) , would it give the desired result? I don't think it would work it only compare the number against the metrics displayed on the graph.
Hi Gary,
I have created a variable like
=aggr(only({$<$(vGrade)-={*}>} Name), Name) - but getting null values everywhere.