I have a dashboard with a dimension filter. The dimension filter table is a list of organizations and the products associated with those organizations. I have a widget displaying organization and product buy counts. When I filter on a product ID that...
I have a pivot table listing out test taken. Currently it list all test taken but I only want to show the row if all three test have been taken. So if test A and test C have been completed but not test B then that persons data would be removed. If AB...
I want to use a simple if statement without using aggregation, just logical. How can I get this to work in an indicator widget:IF([is_pec_broadcast_session] = 'Yes', [# of unique session_id],[# of unique user_id])Simply, If is_pec_broadcast_session e...
Hi community,I have a multipass function which isn't doing what I expect from it. In an widget I want to report how many SMS have been send, and if the number is above 5 per "sim_id", the to-be-credited SMS shall be 5. If the number of SMS sent is be...
We have a requirement to filter a BloX widget to the same day of the week a year ago. Example: The dashboard filter is selected to Friday 11/24/2023 We want a particular widget to be filtered to the same day of the week last year: Friday 11/25/2022 N...
Hello,I am attempting to create a widget button in Blox that will switch widgets upon being clicked. Initially, I tried using Tabber for this purpose. However, when exporting to PDF, all widgets become visible with Tabber.Is it possible to accomplish...
We have certain calendar-based metrics that need to be lagged (typically by 15 or 30 days). For instance YTD 2023, but excluding the last 15 days. I haven't been able to figure out how to do this within the basic filter selectors. It's almost like I ...
Hii, I have pivot table merchant names and sales , now i want to color the top 3 and bottom 3 of sales column , top 3 should be green and bottom 3 should be red . How can i achieve that
Assuming that you have a properly-designed dimensional cube structure, with no many-to-many problems... in your experience, what are the biggest factors that influence total cube size? (And therefore Sisense system performance impact, memory utilizat...
My team and I are currently working on a pivot table where we track how slot machines are performing based on their Stand ID (denoting a location on a floor), based on changes made to machines at that location.The "ChangesPivot_v1" attachment shows o...
There are a couple of dimensional modeling patterns that you see out there, that I'm wondering if Sisense supports correctly.1. Snowflaking - (I don't mean Snowflake the database) - having rollup, lower-grain dimensions hung off of other more detaile...
in a typical corporate data warehouse scenario, we'd have a wide range of facts covering different areas of the business. They in turn would likely be set up as different Elasticubes/models that have a small number of facts in each.However, it would ...
Hi All,I need help!!!I want to navigate from the values in pivot table to another dashboard and filtering the selected value in that dashboard.Eg.NameIDSalaryA1231000B4562000C4322300I want to select ID and navigate to dashboard 2 with selected ID fil...
Hello, I was wondering if anyone had any ideas on how to save monthly instances of certain widgets, with their values. I have three widgets that are queried every night, and their values change accordingly. The dashboard that these widgets live on, h...
To add dynamic count Count([id]) to the widget, I just simply type {panel:Count} (screenshot 1). For complex Sisense function (please see my screenshot 2 below) like this one: avg(DDiff([Days in effective_end_date],[Days in effective_start_date])), e...
