Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I need to create a dimension in a graph, which identifies me the first date when the order goes into 'PAI' status.
I am using :
Date(Min({< [order_status_log] ={'PAI'}>} ([event_date_log]),[Order number]),'DD/MM/YYYY')
Which returns me an unfilterable measure. How do I create a filterable dimension in a graph?
Thank you
Order number | event_date_log | order_status_log |
7001022512 | 29/12/2021 16:47 | DRAFT |
7001022512 | 09/02/2022 15:30 | IPF |
7001022512 | 01/07/2022 07:49 | TBF |
7001022512 | 01/07/2022 11:52 | TBF |
7001022512 | 01/07/2022 17:30 | TBF |
7001022512 | 01/07/2022 17:30 | TBF |
7001022512 | 01/07/2022 17:30 | TBF |
7001022512 | 01/07/2022 17:31 | PAI |
7001022512 | 04/07/2022 13:17 | PAI |
7001022512 | 04/07/2022 13:17 | PAI |
7001022512 | 12/07/2022 10:20 | PAI |
7001022512 | 12/07/2022 10:20 | PAI |
7001022512 | 12/07/2022 10:20 | PAI |
7001022512 | 12/07/2022 10:20 | PAI |
7001022512 | 12/07/2022 10:20 | PAI |
7001022512 | 12/07/2022 10:21 | ACT |
Why not just creating a field for the first date in load script, something like:
load [Order number],
date(min(event_date_log)) as first_date
resident [your_table]
where order_status_log = 'PAI'
group by [Order number];
If you want first timestamp instead, just change date() to timestamp()
Unfortunately, I do not have access to the loading script