Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I am having an issue with calculated dimensions in a drill-down. I created a really basic example I'm attaching.
In the example, I have 'dim1' 1, 2 and 3, if you click on dim1 you'll get 15 IDs in a stacked bar graph. 1 ID is 'top' and the other 14 are 'nope'. If click the 'top' area of the bar graph, or click the 'top' option in the legend,the graph filters to the 1 ID.
However, if I click the 14 for 'nope', nothing changes and I can't see the exact 14 IDs that represent 'nope'.
I'm using a conditional statement for the caculated dimension.
" =if(score1 = 100 and score2 = 100 and score3 = 100, 'top', 'nope') "
Why does this happen? How can I circumvent it? Any help would be greatly appreciated!
Try attached
Hope the attached file helps