In this example, expanding on Lumira: Practice Custom Calculation – Aggregation Options I want to evaluate the profit ratios by region. Ideally I would like to develop a score card, or an old “sitrep” (situation report) but perhaps that will need to be done with an SDK.
I review the steps on this video:
Here is the logic statement:
If the profit ratio is greater than .2, then evaluation the ratio as “great”. If the ratio is greater than .10 then it is “good”; otherwise it is “bad”.
In the above I can use the profit ratio as it is a calculated measure.
But I want to display it as a legend on my graph, so I end up creating a similar calculated dimension but then the profit ratio does not exist here so I have to manually create it as shown above.
I review the calculations as a visualization table above.
The above was the best visualization I could get; ideally I would like for this to be a score card showing green for great, yellow for good and red for bad, but perhaps that has to be done using an SDK in Lumira 1.15.