Splitting and filtering heavy line charts
Good morning,
I'm working on the attached CSV file.
I'm looking to represent the "FTSW (%)" attribute in Y , with "Dates" in X (from April 1st to Septembre 15th). I have the data for multiple places ("Plot name") and multiple years ("Year").
I would like to create a line charts from April 1st to September 15th, split by plot (so i can see all the plots at once), and filtered by year (so i can visualize one year at once), like this one but with a "year" button to switch the year.
I'm unable to split by plot other than using a "Mean" aggregation, and splitting by plot. I'm also unable to split the dates properly, so the chart shows me all the dates, which is not great, and makes it unreadable.
How should I proceed ?
Thank you for your help,
Best regards,
Yann
