EDIT: Sample data-set attachedHi there, I'm working on a dashboard that needs to accurately filter inventory records based on dbt snapshot dates (dbt_valid_from and dbt_valid_to) in SiSense. I face a similar challenge to another recent user post using filtered measures.However, due to grouping/aggregation behavior in Sisense — where date fields must be wrapped inside aggregation functions like MIN() or MAX() — the original approach (direct comparisons inside calculated measures) d...

npatel_02 - how many inventory records are involved, and how many stock dates are relevant to the use case? The reason I ask is because a potential modeling solution involves pre-calculating the stock status for each product/date combination. It makes things quite straight-forward, but there are potential limitations depending on data volume / disk size.To limit the size as much as possible, the example would employ 3 tables:Date Dimension: unique list of dates, for dashboa...

Filtered Measures Using Snapshots and Sisense Date Calculations | Help and How-To

MoreDiscussions

Filtered Measures Using Snapshots and Sisense Date Calculations | Help and How-To | Sisense Community