Forum Discussion

RogerSteinberg's avatar
RogerSteinberg
Icon for Post Patron rankPost Patron
5 years ago
Solved

Getting total value per day based on most recent status

I have two tables. A date table with a date column A table with data showing: StatusDateChange,UserId,NewState For each date from the date column, I would like to count for each status group the...
  • Anonymous's avatar
    Anonymous
    5 years ago

    I used my own data, so the figures are correct but different from what you pasted above.

     

    Model

    Table 1

    Table 2

     

    Measure:

    Measure

     

    The measure counts the number of visible users that have their latest status in the set of the visible statuses.