topic Re: Water fall Chart in Dashboards & Analytics Discussions

Water fall Chart

Hitendra — Tue, 07 Jun 2022 14:06:07 GMT

Is there any way to start Margin P1 from zero.

Re: Water fall Chart

michael_ross — Tue, 07 Jun 2022 14:59:17 GMT

It is not possible to have a specific measure render from zero. Each new measure will add or subtract from the previous point in the waterfall. You can add a Column Grand Total from the Settings pane, which will render a total from zero.

However, I am assuming based on the column names in your example that you are trying to do a period to period comparison where your last measure is more of a reference point for comparison, instead of a component of the waterfall.

One option you might consider exploring is the Incorta Component SDK. Here is a link to the knowledgebase article that describes the custom visualizations that can be created through that framework.

https://community.incorta.com/t5/dashboards-analytics/getting-started-with-the-incorta-component-sdk/ta-p/706

Here's an example of a Waterfall chart that could be deployed in that framework.

https://echarts.apache.org/examples/en/editor.html?c=bar-waterfall

Re: Water fall Chart

Hitendra — Wed, 08 Jun 2022 07:25:48 GMT

I am working on PVM(Price volume Mix) bridge for that, I have to show current year margin P1 and previous year margin P2 in water fall chart. Because it's important to show the data in below one .

Re: Water fall Chart

Hitendra — Wed, 08 Jun 2022 08:24:49 GMT

In Qlik there is an option in Pill(Measure column like. amount, margin e.g.) call subtotal with the help of that, I can do it. But in Incorta I didn't find any. If any other way to to that pls suggest.