Chart - show value for every 15 min

[#1]

Hi,

I have a few thousand data points every day and I would like to illustrate it in a chart.

However, showing all of the dimension data points does not work pls see below:

I need to show fewer values across the day. Maybe one every 15 minutes.

I was thinking somehow maybe pick the last value for every 15 minutes.

Any ideas?

Pls find attached example file.

Regards

//Olle 

[Anonymous · Accepted solution]

The attached shows average balance over 15 minute time buckets.

[rubenmarin]

Hi Olle, this attachment shows, each 15 minutes, the value of the last value in that period.

If you load TIME as a time (number) you can avoid the Time#() in graphs.

[Anonymous]

I would personally put into the load script the code to create a new field for the 15 minute buckets which can then be used as your dimension.

Calculated dimensions should always be avoided where possible, but I often use them in cases like this to first test a theory before putting it in the script.