Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am struggling to get something working in a chart.
Basically i have data like the following..
So what i am trying to do is get the name associated to the ReadingDate that matches the DueDate, so in this case i would want to return name C.
Can anyone help please? Sample attached
ReadingDate | DueDate | Name |
01/01/2018 | 10/08/2018 | A |
02/03/2018 | 10/08/2018 | A |
10/08/2018 | 10/08/2018 | C |
12/08/2018 | 10/08/2018 | B |
15/09/2018 | 10/08/2018 | B |
05/10/2018 | 10/08/2018 | D |
Maybe:
Try this
Concat(DISTINCT if(ReadingDate=DueDate,Name), ', ')
Hi Sunny,
I need to make a change to this but i can't seem to get it to work.
What i need is to compare the ReadingDate to the max DueDate.
I have tried wrapping max() around the DueDate but it doesn't seem to work.
Any suggestions?
New sample attached.
May be this
Concat(DISTINCT Aggr(If(ReadingDate = Max(TOTAL <Customer> DueDate), Name), Customer, ReadingDate), ', ')
Hi
How about handling it in scrip(as I did in attached sample)?