Forum Discussion

Bruno's avatar
Bruno
Cloud Apps
02-25-2025
Solved

Filter on first events in period

I have a requirement to filter a fact table by the first event for each user in a period. e.g with user A B and C 1: user A  - 02 jan 2024 2: user B  - 04 jan 2024 3: user A  - 05 jan 2024 ...
dashboards & reporting
  • Bruno's avatar
    Bruno
    03-05-2025

    Hi David,

    It's possible that Assaf's multi-pass solution might work. However we have internally decided that the generated SQL would be too costly to run on a dashboard refresh so we refactored our solution.

    Instead of ranking the events to identify the first in the requested period, we have pre-computed the "previous event date" at DB level and changed our filters to check that the "previous date" is before the requested period's "From date".

    It is functionally equivalent and cheaper to compute at refresh time.

     

DRay's avatar
DRay
Sisense Employee
03-04-2025

Hello Bruno,

I’m following up to see if the solutiona offered by AssafHanina or Jake_Raz worked for you.

If so, please click the 'Accept as Solution' button on the appropriate post. That way other users with the same questions can find the answer. If not, please let us know so that we can continue to help.

Thank you.

Bruno's avatar
Bruno
Cloud Apps
03-05-2025

Hi David,

It's possible that Assaf's multi-pass solution might work. However we have internally decided that the generated SQL would be too costly to run on a dashboard refresh so we refactored our solution.

Instead of ranking the events to identify the first in the requested period, we have pre-computed the "previous event date" at DB level and changed our filters to check that the "previous date" is before the requested period's "From date".

It is functionally equivalent and cheaper to compute at refresh time.

 

  • DRay's avatar
    DRay
    Sisense Employee
    03-05-2025

    Thank you for the update!