Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a table below, what i want is to get the updated status of of users and sum all those values and do it in function , any suggestion ?
UserID Date Status Value
A 13/2/2017 Status_A 100
A 13/3/2017 Status_A 100
A 13/6/2017 Status_B 200
A 13/7/2017 Status_B 300
A 13/12/2017 Status_B 400 (So sum all Status_B for A)
B 13/1/2017 Status_C 1
B 13/2/2017 Status_C 2
B 13/12/2017 Status_D 4
The expected result
UserID Status Sum
A Status_B 900 (200+300+400)
B Status_D 4
Thanks in advance
May be this
Dimension
UserID
Expression
FirstSortedValue( Status, - Date)
Sum(Aggr(If(Status = FirstSortedValue(TOTAL <UserID> Status, - Date), Value), UserID, Status, Date))
May be this
Dimension
UserID
Expression
FirstSortedValue( Status, - Date)
Sum(Aggr(If(Status = FirstSortedValue(TOTAL <UserID> Status, - Date), Value), UserID, Status, Date))
thank you for your help, but it seems not working, it give me 0.
thank you for your help, but it seems not working, it give me 0.
I want to show it in bar chart actually,
so that the the chart show below
Status B Status D
Not sure I understand... what is your bar chart dimension? Status?
imy mistake, it works, thxSunny