Forum Discussion
Seeking Optimal Approach: Creating Visuals for Clustered Column Chart
Im not sure that I follow what you are thinking... I need to calculated all the values with the same percentage, so that I can see what happens if all the values decreases with 10-15-25%. Hopefully you understand what I mean:) If you see my column chart you can see that I have 4 different bars with the original data and then the stressed values.
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?