Laflet
Cloud Apps
Joined 01-31-2023
User Profile
User Widgets
Contributions
Filter to only show Relevant Dimension Values
Morning Sisense community! I have my Fact Table and a related Dimension Table. My dimension table contains more unique values than are actually present in the fact table. When I use a field from the Dimension Table as a filter, the filter displays all values from the dimension, even those that have no corresponding fact records. I only want the filter to show dimension values that are relevant to the data in the fact table. Example Tables: fact_table dimension_table id dim_id dim_id dim_name 1 1 1 one 2 2 2 two 3 1 3 three 4 2 4 four fact_table and dimension_table have a relationship in the EC based on dim_id Desired Outcome: In the filter based on dim_name, I only want to see "one" and "two", but currently, I see all four: "one," "two," "three," and "four." How do I achieve my desired outcome?Re: Filtering Orders by Grouped Filter Criteria with Optional Nulls
Thank you for raising this point. You are correct that selecting from all possible combinations of location_id, category_id, and client_id would be impractical, resulting in hundreds of possible unique permutations. We can clarify the requirement as follows: Combination vs. Grouping: We are not requesting every possible combination. The need is for a set of specific, predefined groupings of these three fields, as established and utilized within the source application. Current Scope: We currently maintain 10 distinct filter groups that must be reflected. Functionality: These groups serve as preset filter defaults, enabling our users to quickly filter the dashboard to specific, validated business segments. Essentially, we need to load and apply these 10 predefined, complex filters (each a specific combination of the three IDs) rather than allowing the user to select from an exhaustive list of all possible combinations.72Views0likes1CommentSeeking Best Practice for Live Detail Reporting in Sisense (Replacing SSRS)
Afternoon Sisense community, Our team is looking to replicate the functionality of a crucial SSRS report within Sisense. This report is used by a department to obtain a detailed list of jobs for a specific month. The workflow involves: Running the report for a selected month (typically the current or previous month). Reviewing the output for discrepancies. Updating the source system based on the review. Re-running the report immediately to verify the changes (requiring live data). Current Sisense Implementation & Performance Issue I've attempted to recreate this report's dataset using a Live Model connected to a Redshift SQL View. The view is complex: It contains approximately 50 columns of detailed data. It involves JOINs across 15 different tables to consolidate all necessary dimensions and metrics. The Issue: The performance of this Live Model is unacceptable. Users are accustomed to the SSRS report running a stored procedure and returning the filtered data in under 30 seconds. My Sisense Live Model is timing out. Constraints & Goal Requirement: The data must be live (no ElastiCube, as users need immediate reflection of system changes after updates). Target Performance: Sub-30-second return for monthly filtered data. Request for Guidance Given the high number of columns, multiple joins, and the strict requirement for live data with fast filtering (specifically by month), what would be the recommended best practice for implementing this detailed report in Sisense? Are there specific Sisense configurations, data modeling techniques for live connections that would address this performance bottleneck while meeting the "live" requirement? Thank you for your insights!194Views0likes6CommentsFiltering Orders by Grouped Filter Criteria with Optional Nulls
Afternoon SS community, We need a filtering mechanism in our business where users can apply filter groups to retrieve specific orders. Each filter group consists of three fields: location_id, category_id, and client_id. When a filter value is NULL, it should behave as a wildcard and match all values for that field. The goal is for users to select one or more filter groups at a time and retrieve all matching orders — without returning duplicates, even if the same order matches multiple groups. Currently, I can filter by individual fields, but I’m unsure how to structure things to support grouped filters like this without requiring users to select each field individually. The business requirement is to let users select entire filter groups, not individual filters. Sample Data: order_id location_id category_id client_id 1 1 1 1 2 1 1 2 3 2 2 3 4 2 3 4 5 2 1 4 Filter Group Examples: Group 1 location_id: 1 category_id: 1 client_id: 1 Expected Result: Order 1 only Group 2 location_id: 1 category_id: 1 client_id: NULL Expected Result: Orders 1 and 2 Group 3 location_id: 2 category_id: NULL client_id: NULL Expected Result: Orders 3, 4, and 5 How can I design a filtering logic that: Accepts multiple filter groups (with NULLs acting as wildcards) Returns all matching orders Avoids duplicate orders if they match more than one group Any guidance or sample query structure would be greatly appreciated! Thanks in advance.247Views0likes6CommentsHow to pivot my data and get counts based on the min and max date value
Morning Sisense community, I need to pivot my data and get counts based on the min and max date value. Given the below data: row date count Example 1/01/2025 35 Example 2 1/01/2025 20 Example 1/02/2025 35 Example 2 1/02/2025 10 Example 1/04/2025 34 Example 2 1/04/2025 10 Example 1/08/2025 34 Example 2 1/08/2025 10 I want to pivot it to: Row Start Count End Count Example 35 34 Example 2 20 10 I need to be able to filter my data in the dashboard. So, if the date is filter to “1/04/2025” to “1/08/2025” in the dashboard, the pivot needs to update to: Row Start Count End Count Example 34 34 Example 2 10 10 How would I achieve this?Solved87Views0likes1CommentPASTYEAR function issue with leap years
Hello Sisense Team, I encountered an issue while using the PASTYEAR function in a column chart with date/month as a category. Specifically, I noticed that there is no data displayed for February 29th from last year. I assume this is because the current year isn't a leap year. Could you please advise on how to resolve this issue? I'm looking to return the current year's values split by months, alongside last year's values. Last year's values should display regardless of whether or not i have a value this year. Any guidance or solutions would be greatly appreciated! Thank you.39Views0likes1CommentFiltering Inventory Dashboard to a Specific Date Using dbt Snapshot (valid_from/valid_to)
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_id location_id quantity_on_hand dbt_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.Solved698Views0likes4CommentsRe: Pivot2: "Clickable URL Links In Pivot Rows" Re-Implemented
What’s the advantage of this method compared with: https://community.sisense.com/t5/knowledge/clickable-url-links-in-pivot-rows/ta-p/9592 Personally, i would have thought that enabling “Allow rendering Pivot Table content as HTML“ would be preferred.1.2KViews0likes0Comments