Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a combo chart. There is one measure that I'd like to be dependent on the dimension, and another measure that I'd like to be independent of the dimension, i.e. not tied to the dimension. What I'm trying to accomplish is to have a straight line that shows a fixed percentage (for example 87%). Below is the expression that shows a percentage that I would like to be independent from the dimension:
Count({1} if([field1], [field2]))
/
Count({1} [field2])
Any help is greatly appreciated.
Thanks,
Shu
I had the wrong approach to this problem. What I did not realize I needed was a reference line in a bar chart. If anyone encountered a similar issue, a reference line is located in Add-ons > Reference Lines. Then you can add your expression or value as needed.