Reporting - Line chart by split by branch
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Labels:
- Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
That's great thanks. Was the transform section I was missing. Thanks a million for that.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Great if this works can you mark it as the solution too?
