Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I have input like below.
Metric | Target | Description | Date |
M1 | 95 | T2 95% in 8 Hours | 1.2022 |
M1 | 95 | T2 95% in 8 Hours | 2.2022 |
M1 | 100 | T2 100% in 8 Hours | 3.2022 |
M1 | 100 | T2 100% in 8 Hours | 4.2022 |
M1 | 90 | T2 90% in 8 Hours | 5.2022 |
Output should like this:
Metric | Target | Description | From Date | To Date |
M1 | 95 | T2 95% in 8 Hours | 1.2022 | 2.2022 |
M1 | 100 | T2 100% in 8 Hours | 3.2022 | 4.2022 |
M1 | 90 | T2 90% in 8 Hours | 5.2022 | null |
Can you please suggest/help on how can i transform data input into output as shown above..
The OUPTPUT table has
3 dimensions
and 2 expressions
Date(Min(Date#(Date, 'M.YYYY')), 'M.YYYY')
IF(COUNT(Date)=1, NULL(), Date(Max(Date#(Date, 'M.YYYY')), 'M.YYYY') )
The OUPTPUT table has
3 dimensions
and 2 expressions
Date(Min(Date#(Date, 'M.YYYY')), 'M.YYYY')
IF(COUNT(Date)=1, NULL(), Date(Max(Date#(Date, 'M.YYYY')), 'M.YYYY') )
Hi Maxgro,
Wonderful, thanks a lot for your help:)