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,

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

**Running Calculation:**

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

Hence,

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

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

**Moving Average:**

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

**Percentage:**

This is simply a percentage calculation.

**Difference From:**

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)

**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

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

Rgds,

Murali

Helpfull, Murali…

Thanks

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?