Waterfall chart - Difference analysis with 2 totals (Attachment .dxp)

[Xavier Hess]

Hello,

After checking for some time, including this TIBCO Community article, I could not figure out how to reproduce a waterfall chart created originally in Microsoft Excel.

The attached .dxp contains the screenshot, a description of the issue and the embedded dataset.

Any idea on how to reproduce the Microsoft Excel waterfall chart

Thank you.

Kind regards.

[David Boot-Olazabal]

Dear Anne,

 

Please have a look at the attached waterfall dashboard. My waterfall visualization is the one in the lower right corner and uses a different kind of expression.

Kind regards,

David

[Xavier Hess]

Hello David,

Thank you very much for having accepted the challenge and attached the result. I really appreciate that you used some of your time on this report. :)

I was hoping to avoid creating one column for each category. If a new category appears, the chart will need to be updated.

We will need to cope with this way until Spotfire will be able to proceed without "hardcoding the columns".

Kind regards.