how can we show 3 axis chart
suppose in my data there are columns like company name, week , current year sale, last year sale, last to last year sale
i want to visualize the data
eg for company ABC week 1 all 3 years sale should be plot in same chart
company name | week | current year sales | last year sales | last to last year sales |
ABC | week 1 | 142 | 145 | 200 |
ABC | week2 | 439 | 458 | 451 |
ABC | week3 | 0 | 152 | 175 |
ABC | week4 | 485 | 425 | 399 |
XYZ | week 1 | 745 | 785 | 895 |
XYZ | week2 | 748 | 658 | 422 |
XYZ | week3 | 782 | 756 | 690 |
XYZ | week4 | 842 | 852 | 852 |
I assume that you want to do the visualization in Alteryx. The Interactive Chart Tool can do that for you. You can show 3 values by defining 3 layers in the bar chart.
Dawn.
thank you