Value with last update

[antonaks]

Hello Colleagues!

I have an issue, and can't solve it.

For example, I have data like in table:

Client	Date	Update time	Result
AAA	03-05-18	14:30	910.29
AAA	03-05-18	13:25	181.11
AAA	03-05-18	12:10	616.89
AAA	02-05-18	15:40	890.93
AAA	02-05-18	12:30	25.52
BBB	03-05-18	19:48	969.58
BBB	03-05-18	15:08	759.28
BBB	03-05-18	13:34	276.29
BBB	03-05-18	10:22	493.25
BBB	02-05-18	12:10	657.09
BBB	02-05-18	15:40	516.63
CCC	03-05-18	14:30	496.91
CCC	02-05-18	13:25	499.3
CCC	02-05-18	12:10	932.85

I what create expression with set analysis which will get values in latest update time, but group by client and day.

I know how it make in load script, but I need set analysis expression for use it in chart.

Final result should be like this -

Final result
AAA	03-05-18	14:30	910.29
AAA	02-05-18	15:40	890.93
BBB	03-05-18	19:48	969.58
BBB	02-05-18	15:40	516.63
CCC	03-05-18	14:30	496.91
CCC	02-05-18	13:25	499.3

Thanks for any help.

[jyothish8807]

Hi Anton,

You do not require sum() function in this case, simply use first sorted value as mentioned in above example.

Br,

KC

[antonaks]

But I have another dimensions in main table. Like Dates and Accounts.

If I will use only "first sorted value" I will get only one value, but I need sum().

[antonaks]

I can share a full data table if it helps.

[jyothish8807]

Hi Anton,

Yes, that will be really helpful along with the expected output

Br,

KC