Explaining Calculations in Lumira with sample data
Here I would like to brief about the types of calculations available in Lumira for a Measure.
Let’s consider the following sample data,
Here Month is a dimension and Value is a measure
Import this data into Lumira
After the import and adding the fields under Dimensions and Measures, it would be as follows,
Let’s analyse each of the following calculations available for a measure
This is nothing but accumulating the value with all the previous values
In our case, for the month of Jan we have 10, and for Feb, its 20.
In case of running calculations, the value of Feb would be added to the value of Jan
Feb would contain 30(=10+20) as a value.
Similarly Mar would contain 40(10+20+10) as a value.
This is calculating the moving average of value using previous two(if values before set as 2) values
In our case, Mar would have the average of previous two values.
Mar has value 10, so moving avg for Mar would be (10+20)/2 = 15
Apr has value 30, so moving avg for Apr would be (20+10)/2 = 15
May has value 5, so moving avg for May would be (30+10)/2 = 20 and so on
This is simply a percentage calculation.
Here we can find a difference from Previous/Next/First/Last values
In our example,
Feb would get 10, which is (20-10)
Mar would get -10, which is (10-20)
Apr would get 20, which is (30-10)
Through this option, we can create custom calculations based on the predefined formulas available.
For our example, I have shown “if-else” formula, when the value become 10 show “Yes”, and “No” for other values
Thanks for reading this article. Hope this help you to understand the calculations available in Lumira for a measure.
I am trying to create a Crosstab with 2 Dimensions: Distributor Name, Year and 1 fact: Claim_Amt. And I need to create a variance between the Years and I was able to do so using 'Difference From' but I have an empty column between 2016 Claim amt & 2017 Claim amt. How do I remove this?