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.

[maxgro]

in a straight table chart

- add 2 dimensions, Client, Date

- add 2 expression

    max([Update time])

    FirstSortedValue(Result, -[Update time])

[Anil_Babu_Samineni]

Check this?

Create Table

Dimensions - Client and Date

Expressions are

1) Time(Max([Update time]),'hh:mm')

2) FirstSortedValue(Result, -[Update time])

[sasiparupudi1]

expression

Time(Max(Aggr(Max([Update time]),Client,Date)),'h h:mm')

[antonaks]

Hello everybody. Thank you for help. I'm sorry but I forgot mention one special thing.

In final table I need compare last update value with previous in the same day.

[jyothish8807 · Accepted solution]

Hi Anton,

Try this:

- add 2 dimensions, Client, Date

- add 4 expression

    max([Update time])

    FirstSortedValue(Result, -[Update time])

   max([Update time],2)

   FirstSortedValue(Result, -[Update time],2)

Br,

KC

[jyothish8807]

Pfa

[antonaks]

Thank you very much!

[jyothish8807]

You are welcome

[antonaks]

I'm sorry.

Maybe you can help me again.

I still have problem with FirstSortedValue function.
Expression returned sum() for only one Client. I think I should use Aggr function, but I don't know how to input it in my expression.