Forum Discussion
Solved
Waterfall Chart - Current vs. Prior
I want to build a waterfall chart that shows how / why cost increased over time from one month to the next. For now I'm looking at two periods: Last Month and This Month. What I'd like is this: ...
Okay, I figured it out. Solution below for posterity:
- Built measures for the delta between current and prior month
- Updated my "Waterfall Value" measure to use: CPP Prior Month (total), Net Freight Delta, Fuel Delta, Accessorial Delta
- Added a total column which reprents the curent month
It looks like this:
Okay, I figured it out. Solution below for posterity:
- Built measures for the delta between current and prior month
- Updated my "Waterfall Value" measure to use: CPP Prior Month (total), Net Freight Delta, Fuel Delta, Accessorial Delta
- Added a total column which reprents the curent month
It looks like this:
Hi Bensiqc,
Can you share how you build the "Waterfall Value" measure to use: CPP Prior Month (total), Net Freight Delta, Fuel Delta, Accessorial Delta?
I want to build similar waterfall chart but I do not know what measures to create in order to achieve this.
Thanks, Doris
Here's what I have.
My waterfall measure is written this way:
And I have a separate sheet where I add the index for those that looks like this:Measure Index CPP Prior Month 1 Net Freight Per Package Current vs Prior 2 Fuel Per Package Current Vs Prior 3 Accessorial Per Package Current Vs Prior 4 CPP Current Month 5 Hopefully this helps.Each of the measures referenced in the table (fuel per package current vs prior, etc.) were also created and added by me individually.