How can I get a similar chart with every value as a dot for a given date?
My data has multiple value for each date and I can only get a line chart with aggregation on the measure. I want to plot every single value for each date.
Measurements captured multiple time on a day throughout the year.
Try creating a scatter plot or just display the values in a pivot table.
If I use a scatterplot what would be the measures and dimension?
X-axis: Only([Date Local])
Dimension: [Sample Measurement]
Maybe create a timestamp from your date and time and use this as dimension.
Thanks for the suggestion. It worked. Basically the dimension used should be a unique value in my case Timestamp.
Now I my chart looks like this due to the density of the dots. How can I make it look like the picture in my initial question. Also how can I adjust the grid lines to be month wise.
Retrieving data ...