Hourly Max per day

[monica]

Good day

I am new and I am stuck.I have a data set that has different sales figures per hour as shown below.I would like to show the maximum sales figure on a KPI. May you please help with an expression.Thank you in advance.

[JordyWegman]

Hi Monica,

Is it the maximum sales figure for the total data set? Or for each hour?

Use this code if you want the maximum sales for the complete data set:

Max(Sales)

Jordy,

Climber

[monica]

Hi Jordy

I want to get the maximum sales for the previous 18/03/2019.I want it to automatically update.I have made some amendments to the data set.

[JordyWegman]

Hi Monica,

If you want to know the max from the day before you should do the following things.

1. First get to know the maximum date and subtract one from it

Load
     Max(Date)-1 as MaxPreviousDate
From (Your source);

2. Get this date in set analysis in your Max(Sales) formula (this is a front-end formula)

Max({$< Date = {"$(MaxPreviousDate)"}>}Sales)

Then you have your KPI value.

Jordy

Climber