Hi Team,
This is my Table on excel -
Total | Car | Bike | Bus | |
02-09-2019 | 14 | 7 | 6 | 1 |
03-09-2019 | 21 | 8 | 0 | 13 |
04-09-2019 | 42 | 6 | 4 | 32 |
05-09-2019 | 31 | 4 | 11 | 16 |
06-09-2019 | 10 | 1 | 9 | 0 |
09-09-2019 | 26 | 4 | 2 | 20 |
10-09-2019 | 30 | 3 | 8 | 19 |
11-09-2019 | 32 | 1 | 12 | 19 |
12-09-2019 | 19 | 3 | 10 | 6 |
13-09-2019 | 31 | 8 | 0 | 23 |
16-09-2019 | 23 | 1 | 8 | 14 |
17-09-2019 | 21 | 5 | 4 | 12 |
18-09-2019 | 18 | 1 | 4 | 13 |
19-09-2019 | 7 | 2 | 2 | 3 |
20-09-2019 | 29 | 1 | 1 | 27 |
23-09-2019 | 19 | 4 | 5 | 10 |
24-09-2019 | 17 | 4 | 3 | 10 |
25-09-2019 | 12 | 2 | 3 | 7 |
26-09-2019 | 14 | 0 | 4 | 10 |
27-09-2019 | 32 | 10 | 2 | 20 |
30-09-2019 | 16 | 10 | 9 | 3 |
I want to create a chart exactly like this that I've created in excel? If you could please attached your Workflow.
¡Resuelto! Ir a solución.
hi @clarrock
For the missing Y axis. Check the Use Secondary Y-Axis in the layer that corresponds to your total line
For the missing different colours, go into the Transforms section and the split the by the field that holds the name of the vehicle
Dan
I don't have that option. Why?
@danilang No option as such is it because of the version of alteryx I'm running -
Version - 2018.3.5.52487
The dual axis was added in Version 2019.3. I can't find the earliest version for the transforms feature
Dan
@danilang makes sense now. That why my height of my bar was increasing but the text inside the bars weren't when the data kept changing.
Thanks for the help. Will have to get the version.
@danilang is this possible in Alteryx? So..
My inputs include multiple xlsx files to which I create 4 different cross tabs. Then I form 4 tables and unionize them into 4 records.
I also have another input which is a raw data sheet xlsx file
My output should be such that it places the 4 pivots/cross tabs in one sheet on my excel and the raw data in the second sheet of the same excel file.
When I run also the name of the excel file should change based on the date when run.
Eg - 10.03.2020.xlsx with sheet 1 - includes 4 Cross tabs tables and sheet 2 includes the Raw Data.
Let me know if you require more info.