Alteryx Charts workflow

[clarrock]

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.

[danilang]

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

[henrygeorge]

I don't have that option. Why? 

 

[clarrock]

@danilang No option as such is it because of the version of alteryx I'm running  - 

Version - 2018.3.5.52487

[danilang · Accepted solution]

@clarrock, @henrygeorge 

The dual axis was added in Version 2019.3.  I can't find the earliest version for the transforms feature

Dan

[henrygeorge]

@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.

[henrygeorge]

@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.