How to plot every value of a measure?

[Anonymous]

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.

[Ivan_Bozov]

Try creating a scatter plot or just display the values in a pivot table.

[swuehl]

Maybe create a timestamp from your date and time and use this as dimension.

[Anonymous]

If I use a scatterplot what would be the measures and dimension?

[Ivan_Bozov]

Try this:

X-axis: Only([Date Local])

Y-axis: Only(Time)

Dimension: [Sample Measurement]

[Anonymous]

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.