Set analysis - Average when date is equal to...

[brunolelli87]

Hello guys,

I've a database with the following content and format:

Data	Azul
23/03/2021 09:15:33	32
23/03/2021 09:17:33	30
23/03/2021 09:19:33	35
23/03/2021 09:22:33	39
...	...
24/03/2021 03:15:33	32
24/03/2021 03:17:33	30
24/03/2021 03:19:33	35
24/03/2021 03:22:33	39
...	...

So, as you can see, I'm basically collecting the Azul's value every two minutes...

My question is:

How can I create a chart in order to show:

Time (from 00:00:00 to 23:59:59) as my X axle - Dimension
Average of Azul as my Y axle PER DAY - Expression

So, my chart should look something like this:

How can I do that?

Thanks

[MayilVahanan · Accepted solution]

HI @brunolelli87 

Bring time field from script like 

Load *, time(Data) as TimeData, Date(floor(Data),'DD/MM/YYYY') as Date from ursource;

In front end, 

Dim: TimeData

Exp1: Sum({<Date ={"$(=Date(Max(Date),'DD/MM/YYYY'))"}>}Azul)

Exp2: Sum({<Date ={"$(=Date(Max(Date)-1,'DD/MM/YYYY'))"}>}Azul)

[brunolelli87]

Thank you so much!

I really appreciate your help!