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