Show last measured value from the group of multiple measurements

[#1]

Hello Community,

I am trying to solve one task, maybe simple but I just do not know how to do that.

I am building visualization dashboard for quick check of process data.

We have multiple types of product with multiple parameters which are measured in time order.

Loaded data looks like this:

You can see, each individual measurement is recorded to a row, with timestamp and type of product (Glaze_Name) and parameter.

Now I need to create text object which will show most recent measured value of one parameter (for each parameter and product type there will be separate text object).

So I guess it will be expression with set. I was able to put:

=sum({<Glaze_ID =  {9}, Glaze_Parameter_ID = {1},

KeyDate = {'$(=Max(Date(KeyDate)))'},

KeyTime = {'$(=Max(KeyTime))'}>} MeasuredValue)

which returns 0 (not working).

But for the Humidity (marked with green) a several records per date are made. So if I create only max date expression, result is sum of all measurement for the day.

But I need to display only value, which is most recent (27,22) after each reload (dashboard will be in production area).

Help will be appreciated 🙂

Thanks

Tomas

[Gysbert_Wassenaar]

Try FirstSortedValue(MeasuredValue, -HelpTime). Replace HelpTime with the field name that contains the datetime value.

[#3]

Thank you very much, this works!