Formula Help
Hi Everyone, I need to create a formula for an indicator widget which will count all rows in a certain column that meets a condition divided by all rows in that column. For clarity, I want to count all Hardware Types where the power condition is on, divided by count of all hardware types. I am sure this is a really easy formula to put in, but I just cant seem to get it to work. Thanks!Solved40Views0likes4CommentsHow to Dynamically Switch Between Multiple Data Models in a Single Dashboard?
Hello I am building a dashboard where different user groups need to view similar KPIs sourced from different ElastiCubes. For example; one group uses the Sales_US model & another uses Sales_EU. Rather than duplicating dashboards for each data model, I am exploring ways to dynamically switch between data sources within a single dashboard using a parameter or user/group attribute.๐ Has anyone implemented a solution where the dashboard automatically pulls from the relevant data model based on user login, group / a dropdown selector? ๐ Ideally; I would like to avoid duplicating widgets and dashboards, and instead create a flexible design that changes context based on the selected (or detected) model.๐คChecked https://docs.sisense.com/main/SisenseLinux/embedding-dashboards-and-widgets.htm related to this and found it quite informative. If this isnโt natively supported, are there any creative workarounds using Sisense Blox, embedding API / script-based redirection/Generative AI Course ? ๐ Iโm open to hybrid approaches as long as they maintain a good user experience. Thanks in advance!๐24Views0likes2CommentsCASE WHEN syntax w/ multiple conditions
We're trying to build a formula using CASE WHEN syntax with multiple conditions using AND. Example: CASE WHEN MIN(MNDIFF([time A], [time B])) <= 30 AND [column A]='Value' THEN DUPCOUNT([column B]) ELSE 0 This syntax is not working. Any tips?284Views0likes5CommentsDisappearing widgets
Hello, I am duplicating a widget in the report builder and the widget is displayed in the same row as the original. Then when I switch to a different tab (using tabber) and come back, the duplicated widget is gone. If I delete everything and start from scratch it seems to resolve.65Views0likes8CommentsJavaScript does not work for Tabber
I added the following JavaScript to my tabber widget. However it does not execute. I found this JavaScript in a help article on the Sisense Community website. It is designed to change the dashboard filters based on which tab is selected. Can you please tell me what I need to do make this script work? My work around was to hide the dashboard filter and disabling the dashboard filter on each widget and creating a widget level filter. $('.listDefaultCSS .listItemDefaultCSS', element).on('click', function(s){ widget.scriptConfig = true; filter = prism.activeDashboard.filters.$$items.find(el=>el.jaql.title == 'Checklist Type') //Title of filter //mapping of Tab name and filter item. Here when Tab1 is selected, 'Onboarding' will get selected in Checklists Type filter var tabFilterMapping = { 'Tab1':"Onboarding", 'Tab2':"Advancement" } var filterValue = tabFilterMapping[$(s)[0].currentTarget.innerHTML] filter.jaql.filter = { "explicit": true, "multiSelection": false, "members": [ filterValue ] } var filterOptions = { save: true, refresh: true, } prism.activeDashboard.filters.update(filter, filterOptions) }) ; });34Views0likes2CommentsWhen leaving the tabber edit interface
A major UI bug is encountered when applying changes in the Tabber interface. The resulting view is unusable and I need to toggle a different tab and back again to get the visuals to display properly. This should show centered Titles and data in the various widgets.31Views0likes2CommentsJump to with Tabber
I have a KPI dashboard using Tabber with 2 tab, FIRST vs EVER. This KPI dashboard also has a Jump To button and the Jump To dashboard has the same 2 tabs, FIRST vs EVER. Is there a way to pass the Tabber selection on the KPI dashboard to the Jump To dashboard? Currently, I have to select the appropriate tab once the Jump To opens.203Views0likes4Comments