-
1. Re: Waterfall
Mahfooj Khan Apr 6, 2016 10:53 AM (in response to Shipra Manchanda)Hi,
Just follow the below steps to create a waterfall chart.
Drag a dimension to the Columns Shelf and a measure to the Rows Shelf. I’ve right-clicked and dragged continuous (green) quarter onto the Columns Shelf and Profit onto the Rows Shelf.
4) Right-click on the quarter field on the Columns Shelf to convert it to “Discrete”.
*Be careful at this step that your drop-down looks exactly like the drop-down above. You should have the second option for Quarter selected (Q2 2011) and then select the Discrete option.
5) Add a Running Sum of Total Table Calculation to the measure on the rows shelf. To do this, right-click on the Profit pill, select Add Table Calculation, and add the following table calculation:
6) Change the mark type from Automatic to Gantt Bar in the Marks Card.
7) Create a calculated filed named “-Profit” and write the following formula: -[Profit]
8) Drag the new measure “- Profit” to the size tab on the Marks Card. Previously, we only had a singular line denoting where the Running Sum of Profit stood from one quarter to the next. We want to backfill all of the space from one bar to the next and therefore show the growth (or contraction) in profit from one quarter to the next. Positive values will therefore extend our bar upwards and negative values will extend the bar downwards.
9) Add the Profit measure to the color tab on the marks card and edit the colors and change the color palette to be two stepped.
10) If you followed all of those steps, you should now have a working waterfall chart showing growth and contraction in profit from one quarter to the next. Pretty cool!
I hope this will help you.
Mahfooj
-
-
3. Re: Waterfall
Mahfooj Khan Apr 6, 2016 10:23 PM (in response to Shipra Manchanda)If I'm not wrong you mean to say the difference in each quarter and year?
In Q1 I want to see the comparison difference of 2010 with 2011. If so then refer the workbook( in version 9.2)
You can also refer the screenshot.
In the chart it will compare the profit of year 2010 with year 2011 and so on along pane across.
I hope this will help you.
feel free to ask if you've any query.
Mahfooj
-
Diff.twbx 1.4 MB
-