Skip to Content

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”.

1calcmeasure.PNG

In the above I can use the profit ratio as it is a calculated measure. 

2calcdimensions.PNG

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.

3tableevaluation.PNG

I review the calculations as a visualization table above.

4chart.PNG

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.

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply