Skip to Content
Author's profile photo Muralikrishnan Ethiraj

Explaining Calculations in Lumira with sample data

Hello Everyone,

Here I would like to brief about the types of calculations available in Lumira for a Measure.

Let’s consider the following sample data,

Capture1.JPG

Here Month is a dimension and Value is a measure

Import this data into Lumira

Capture2.JPG

After the import and adding the fields under Dimensions and Measures, it would be as follows,

Capture3.JPG

Let’s analyse each of the following calculations available for a measure

Capture4.JPG


Running Calculation:

This is nothing but accumulating the value with all the previous values

Capture5.JPG

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

Hence,

Feb would contain 30(=10+20) as a value.

Similarly Mar would contain 40(10+20+10) as a value.

Capture6.JPG

Moving Average:

This is calculating the moving average of value using previous two(if values before set as 2) values

Capture7.JPG

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

Capture8.JPG

Percentage:

This is simply a percentage calculation.

Capture9.JPG

Capture10.JPG

Difference From:

Here we can find a difference from Previous/Next/First/Last values

Capture11.JPG

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)

Capture12.JPG

Custom Calculations:

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

Capture13.JPG

Capture14.JPG

Thanks for reading this article. Hope this help you to understand the calculations available in Lumira for a measure.

Rgds,

Murali

Assigned Tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Helpfull,  Murali...

      Thanks

      Author's profile photo Former Member
      Former Member

      Hi Murali,

      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?