3 Replies Latest reply on Oct 29, 2018 9:10 PM by Deepak Rai

# Evolution Rate - Row and previous row comparison

Hello everyone,

I'm new on Tableau and try to compute some statistics through the "Calculated Field" menu. I'm sorry if this question was too often asked but I haven't found yet my answer among old posts.

I tried to compute an evolutiaDon rate of the price as following : ( Price (t) / Price (t-1) ) - 1

So I tried so formula in the calculated field editor :

1)

(LOOKUP(SUM([Price]), 0) / LOOKUP(SUM([Price]), -1)) - 1

2)

Both are valid according to the editor but both created columns are full of "Undefined" values and a warning message is displayed at the top of each of them : "this field contains an aggregate calculation which only contains meaningful data in the visualization's level of detail". What does it mean exactly please ? Do you know which formula is right to calculate this evolution rate between 2 prices ?

Best regards,

Hicboux

• ###### 1. Re: Evolution Rate - Row and previous row comparison

Hi Hic,

Thanks

Deepak

• ###### 2. Re: Evolution Rate - Row and previous row comparison

Hi Deepak,

I join then my workbook with this reply as "help.twb". The related calculated fields are "Price Comparison 1" and "Price Comparison 2". Thanks for your help.

Best regards,

Hicboux

• ###### 3. Re: Evolution Rate - Row and previous row comparison

It all Depends upon what you want to keep in view for Comparison to Be made of, Your FIREST CALC is FINE.

I kept Country Then you get this.

Now When you add Year to View and Restart for each Country Then this is the Result for Same Calculation, Use Calculation 1 Only.

Thanks

Deepak