Min value for each hour

[Alonal148]

Hello,

Please advise how can I recive the Min sales per Hour as in the bellow example.

: 

Thank you,

Alona

[PriyankaShivhare]

hope this helps,
min(aggr(sum(sales,hour))
Thanks,
Priyanka

[MayilVahanan]

Hi @Alonal148 

Try like below

Min(Total<Hour>Sales)

[Alonal148]

Thank you. It's works

[Alonal148]

Thank you for your help.

The function Min(Total<Hour>Sales) sloved the issue.

[MayilVahanan]

Hi @Alonal148 

Can you close the thread by marking correct answer