Total Count does not add up when filtering between Line Chart and Stacked Column Chart

[Anonymous]

Hi Everyone,

When I click on one of the "location" column, it will filter the Line Chart and Product Categories chart.

The product categories chart values will add up to 36. But the line chart which is breaking down into the months of 2023 does not add up to 36. May I know why? Is it showing average across each month?

I want to show the breakdown across each month so that it adds up to 36.

Additional Information:

Date Filter applied: The year of 2023

Location and Product Categories is filtered to show the "Top 20".

All 3 graphs are showing the Distinct Count of Product ID.

[ChiragGarg2512]

@Anonymous , As the 3 graphs are showing distinct count of product ID. So, when a location is set, in product categories data is distributed by how many product ID belong to which category, hence adding upto 36. But in line graph it shows how many distinct product IDs are sold for that location in each month.

If somehow the distinct count can be taken of the whole line graph, that will be 36. Meaning that there are similar product IDs for two or more different months.