Waterfall Chart from two tables

Anonymous · ‎11-17-2021

Hi Folks,

I'm looking to build a proper waterchart like so:

I have indeed followed the guide to the upper limit, however I am struggling because I don't have set variables dictating my buckets. (https://www.youtube.com/watch?v=BfACOEiPK8M)

The current model I have is with two tables.

Table 1 carries the Sum for the years, or the totals each side.

Table 2 carries all the differences between years one and two. The trick is however, that Table 1 is deduplicated counts. So there might be overlap between the Sources. I'm showing the deduplicated counts and how they change over time in line with the counts.

Can someone please help me and explain what to do here to link the two tables as well as get the Start and end bars either side?

Thanks!

Anonymous · ‎11-21-2021

HI @Anonymous,

I check your snapshots but did not find any obvious relationship key in your sample. Did any field that stores the same value in both two tables? If that is the case, you can use this field as a relationship key to mapping two table records.

In addition, can you please share some more detailed information? It should help us clarify your scenario and test.

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng