I am trying to create a dashboard that will show details on water quality testing across multiple sampling sites. I would like to have a serial chart show the concentrations of Ammonium, Nitrates, and Dissolved Oxygen graphed out in a line graph. I can create a line graph and filter it by selecting the sampling sites but I want to refine the graph further. As of now, the x-axis shows the exact date of each sample, because there are so many samples the dates get cluttered (see attached jpg). Therefore I would like to only show the months and years on the x-axis and allow users to see the exact date of each sample by hovering over the data point. I have not figured out how to do this and would like to know if anyone has accomplished that before? I would appreciate any workflows and feedback.
Thanks for your time,