Filtering Inventory Dashboard to a Specific Date Using dbt Snapshot (valid_from/valid_to) | Help and How-To

Luke Flett · 2025-04-17T04:28:25.881000Z

Hi Sisense Community,I'm working on an inventory dashboard in Sisense and I'm using dbt Snapshots to maintain historical inventory data. My snapshot table includes dbt_valid_from and dbt_valid_to columns to track the period for which each inventory record was valid.I want to enable users to filter the dashboard to a specific date and see the inventory position on that exact day. For example, if a user selects "12/04/2025" (April 12, 2025), the dashboard should display the inventory levels as they were on that date, based on the dbt_valid_from and dbt_valid_to ranges.My inventory_history table in the ElastiCube has the following relevant columns:product_idlocation_idquantity_on_handdbt_valid_from (Date/Timestamp)dbt_valid_to (Date/Timestamp, can be NULL for current records)I'm looking for the best way to implement a filter that allows users to select a single "Inventory Position Date" and then filter my inventory widgets to show only the records where the selected date falls within the dbt_valid_from and dbt_valid_to range (or dbt_valid_from is before the selected date and dbt_valid_to is NULL).Specifically, I'm wondering:What is the best approach to allow users to select a single date for this filtering? How would I create the necessary logic (likely a Calculated Field) in the ElastiCube to determine if an inventory record was valid on the selected date? I need to compare the selected date with the dbt_valid_from and dbt_valid_to columns, handling the NULL value in dbt_valid_to for current records.How would I then use this calculated field (or another method) to filter my inventory widgets to show the correct data for the selected date?Any guidance, examples of calculated field formulas, or best practices for implementing this type of point-in-time filtering in Sisense would be greatly appreciated!Thanks in advance for your help.

MoreDiscussions

Filtering Inventory Dashboard to a Specific Date Using dbt Snapshot (valid_from/valid_to) | Help and How-To | Sisense Community