5 Replies Latest reply on Oct 27, 2016 1:13 AM by Norbert Maijoor

# How to compare a measure among different period

Hi,

Need help! My source table (order margin) is as below

 Order Apr-16 May-16 Jun-16 Jul-16 Aug-16 Sep-16 A 8.10% 8.10% 8.10% 9.20% 9.20% 6.50% B 12.60% 17.50% 17.50% 17.50% 17.50% 13.60% C 22.10% 22.10% 22.10% 22.10% 22.10% 22.10% D 17.80% 17.80% 17.80% 18.80% 18.80% 18.80% E 21.30% 21.30% 23.50% 21.30% 21.30% 23.50%

What I want to achieve in Tableau is to show below result

 Sep-16 vs Aug-16 Sep-16 vs Jun-16 No of Order No of Order Order with  improved margin 1 1 Order with  decreased margin 2 2 Order with  margin - no change 2 2

Any idea? Thanks a lot!

Emily

• ###### 1. Re: How to compare a measure among different period

Hi Emily,

From the "Top of my head" a could come up with the following approach depicted below and stored in attached workbook version 9.3.

Not sure if it will meet all your requirements...

• ###### 2. Re: How to compare a measure among different period

Thanks Norbert! I downloaded your workbook but was not able to view it coz the calculations are invalid, I tried with both 9.3 and 10.0....

Emily

• ###### 3. Re: How to compare a measure among different period

Good morning Emily,

Hmmmm...strange. The version of the workbook is 9.3.7

I trial to explain the steps.

A. Define the parameters "Date Low" and "Date High" based on the Dimension "Date

B. Define the Dimensions "Date Low" and "Date High" based on the resp. created Parameters

C. Define the measures  "Value Date Low" and "Value Date High"

D. Define the measure "Difference"

E. Define the measure "Order Status"

F. Define the measure "Order with decreased Margin"

G. Define the measure " Order with improved Margin"

H. Define the measure "Order With No Margin"

I. Drag all the required object in the right position.

1. Make the parameters visible

2. Drag "Order" and "Order Status" in the Rows shelf

3. Drag "Measure Names" in the Columns shelf and filter on "Order with etc" Measures

Hope it helps...Let me know.

Have a nice one.

• ###### 4. Re: How to compare a measure among different period

Hi Norbert, thanks a lot for the explanation, it works!

• ###### 5. Re: How to compare a measure among different period

Good morning Emily,

Your are welcome. Thanks for the awards. Much appreciated