Sum of Amount of two different table having period number in Column chart

Hi all,

I want to create a Column Chart which takes sum of amounts of two different tables having period numbers. Attached is the sample data -

Expected Output in Column Chart -

I tried to create the Column Chart but my values are not coming correct.

Is there any solution so that my column chart will take data from two different table and populate the values correctly.

Help appreciated!!

Thanks,

Pooja

Page 1 / 1

@pooja.tiwar11 In the config of the Chart, there is the option to stack the KPI's. This should do the trick since you have the same timeseries.

Best

Kevin

Hello Pooja,

stacking columns will not solve your issue as the date dimension is coming from different tables.

I see 2 options here

Easiest one is to create 2 separate charts (no brainer)
Ensure in the backend that these two tables have a direct match between the desired date dimension and the two columns being aggregated. For example, if table A has info about the creation date+Invoice Amount and table B has payment date+Invoice Amount, you need to pick one of these dates and aggregate it

Best,

Gabriel

Sign up