Lumira Logic: Practice Custom Calculations

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.