Forum Discussion

lorentz's avatar
lorentz
New Member
3 years ago
Solved

Dynamic max value by date based on data slicer grouped by cayegory

Hello everyone,   i encounter some difficulties to achieve a particular requirment.   the dataset is the following   the requirement is to obtain the State related to max Date for each Ob...
  • lbendlin's avatar
    3 years ago

    your date slicers need to be fed by an unconnected table.  I also recommend you rethink the "between" setting. A status is a momentary thing. The status for 1a on 19/06/2022 was Modified, not closed.

     

    see attached