Reporting - Line chart by split by branch

[jmd25]

Hi

I am sure this is probably a very easy question, but I have been messing around with the Alteryx reporting tool and I can’t seem to get exactly what I want. I have revenue ([Revenue]) information for various branches ([Branch ID]) by year ([Year]) and month ([Month]). I am trying to get a line chart that displays a single line (different colours) for each branch, showing their revenue by month / year. Although I can get a line or bar chart displaying, it is concatenation the results into a single line or for each bar is aggregates each branch. 

I am sure there is a setting I am missing, but would greatly appreciate any tips.

Thanks

[aatalai · Accepted solution]

@jmd25 take a look at the attached workflow and let me know how you get on.

You want to go to interactive chart, transformation and split by and select branch ID

[jmd25]

That's great thanks. Was the transform section I was missing. Thanks a million for that. 

[aatalai]

Great if this works can you mark it as the solution too?