Forum Discussion
Seeking Optimal Approach: Creating Visuals for Clustered Column Chart
I'm facing a challenge in creating a visual representation of the attached clustered column chart. Currently, I've managed to address this by generating multiple sheets in Excel, which I subsequently...
Yes, so if your original table has 100 rows, then the table I'm proposing has 400 rows:
100 rows for no reduction
100 rows for 10%
100 rows for 15%
100 rows for 25%
All stacked vertically in one table
Then the values in your chart can just be SUM([Value]), legend is [Reduction Type] and x-axis is [LTV Interval].
Ok, now I understand! However my dataset consists of 200K rows and growing so it will soon be around 1 million rows... Will that be too large and not an optimal approach given the numbers of rows?