on 08-11-2021 12:29 PM
Hello,
I face the following problem: I am using numeric points (Chart: Indicator) in my dashboard. I would like to add a coloured threshold to the numeric point - but instead of using an absolute threshold (for example: green colour if value < 100), I want to build a threshold based on a measure from another (linked) data source.
See the following example with two linked data models: Model 1 and Model 2
My goal is to change the colour of Measure M.1 if it is below Measure M.2 to green and to red if it is above Measure M.2.
Thank you and best regards,
Daniel
Hi,
To meet the above requirement we have to do following step.
Step 1 =create a new calculate measure in story
step 2 = in the new calculate measure try to write if condition Measure M.1 if it is below Measure M.2 to green and to red if it is above Measure M.2. (if (m1>m2;1;0))
Step 3 = use the new created measure in the threshold.
Thanks,
Saurabh S.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Saurabh,
thank you very much!
BR,
Daniel
User | Count |
---|---|
75 | |
10 | |
10 | |
7 | |
7 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.