undefined

Not bad! thanks for the comment.

I am trying to create a MEASURE or COLUMN to display on a card the average value of the last hour. I know, that in a table organizing the hierarchies of Date and Time I can show it. But I want to show the value directly on a card, without the need to apply filters, something like the average value of the last hour in real time.

In the following table, specify the following data:

Apply an averange and I arrive at the expected result by applying from a filter panel the selection of the date and time. But the idea is that by default and without applying filters the card can show me the values.

The values shown on the card are the ones I want to get to, but I hope to visualize them directly without having to apply filters. I want to show those same values directly on the card.

Currently I am only applying an AVERANGE, but I do not know how to specify that I calculate the last minute value. Taking as a sample the four registers hs.