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
Solved! Go to 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
That's great thanks. Was the transform section I was missing. Thanks a million for that.
Great if this works can you mark it as the solution too?