Hi all,
I'm trying to create a line chart that can show up to 20 different lines of sales over time (the chart will be large enough to see them all!). There data set looks like below:
Date | Location | Sales |
1/1/20 | City A | 50 |
1/1/20 | City B | 40 |
1/1/20 | City C | 32 |
1/2/20 | City A | 44 |
1/2/20 | City B | 55 |
1/2/20 | City C | 31 |
There are hundreds of cities in the data set so I'm using a Filter pane for the user to select the cities to display.
I have followed this guide to create two filter panes, each with its own 'alternative state' here: https://www.youtube.com/watch?v=LMMGAFgrnc8
How can I adapt this to use just one Filter pane where each city selected produces its own line on a line chart?
Any help is greatly appreciated! Thanks