I'm struggling trying to obtain the last status for an id.
The data I have is as follows:
FACT TABLE (Table1):
The result I want to obtain is the following:
I'm able to obtain the last date:
Hi @andreabrezmes ,
Could you please offer more information about the logic of distinct count of last status over time?
For status "Apples", it is shown in 2018/1/10, but it seemed not show in your result table:
I would like to obtain the last status by month.
Last status for id 1 is "bananas" for january, so "apples" becomes 0. In February we have 2 id's with status "bananas" and in March id 1 becomes "grapes" and id 2 and 3 are "bananas".