Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
The table
Date | ID |
31 Aug 2022 |
a |
31 Aug 2022 |
b |
31 Jul 2022 |
a |
31 Jul 2022 |
b |
31 Jul 2022 | c |
31 Jun 2022 | null |
The request: If there is an ID for the date to return 1 and sum up all the 1's from YTD
The required result: because only 2 months in 2022 has values
Year | result |
2022 | 2 |
How do i create a ytd tracking as such? thank you
in a straight table you can load the year, then measure: if(not isnull(ID) or ID<>'null', count(distinct(ID))