How to have dashboard filters affect a formula filer?
Hi DRay , I have this formula in Sisense Bar Chart: (((([Total CLAIM_CNT]) )/([Total CLAIM_CNT],Prev([@Months in DATE], 12),([@Network Name])))-1) Where I have the Category being Network Name, I also have the Network Name in the Dashboard filter but when I select a Network Name in the Dashboard filter the widget does not filter for my selected Network Name. The Network Name being in the Denominator is to get the Total Claim Count. I also know that the hierarchy for filtering in Sisense is Formula Filter > Widget fitler > then Dashboard filter. Is there anyway to override this behavior? I still need to the overall claim counts to get the percentage by individual network names but still want to filter for the specific network name.17Views0likes2CommentsScatter Map Color Break By
According to Documentation for Scatter Map widget, in the Color section only a numeric field can be used. Has anybody managed or found an alternative on how to use a text field instead? We would like for the Scatter map to be color-coded based on a text field. eg. If i have stores from Walmart or Costco, to be able to color code them differently. (blue for Walmart stores & red for Costco)24Views0likes2CommentsHow to create a week date range with start and end if the week for each week?
Hi DRay Liliia_DevX , I am looking to create a week range for a line/column/bar chart where lets say it is the 30th week of 2024, then the 31st, 2024 and I want the 30th and 31 st week to shows Sep 24 - Sep 31 2024, etc. Is there a way to achieve this within the model or in the back end of a live data model.42Views1like2CommentsFilter 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?65Views1like3CommentsHow to make Switchable Dimension with Radio Buttons
Hi harikm007 DRay I am trying to create a radio button switcable dimensional changer and wanted to see if it can be done with Radio Buttons, my current script is: { "title": "", "style": "", "script": "", "showCarousel": true, "body": [ { "type": "Input.ChoiceSet", "id": "radiotVal", "displayType": "expanded", "layout": "horizontal", "isMultiSelect": false, "value": "1", "choices": [ { "title": "Total Revenue", "value": "1" }, { "title": "Total Quantity", "value": "2" } ] } ], "events": [ { "type": "valueChanged", "elementId": "radiotVal", "actions": [ { "type": "SwitchMeasure", "title": "DEBUG: event fires?", "script": "console.log('[BloX] valueChanged fired, selectVal=', {{radiotVal.value}}); alert('Radio changed to ' + {{radiotVal.value}});" } ] } ], "actions": [] } The radio buttons show up but they do not switch the measures for the widgets I targeted. I am also okay with not specifically targeting widgets but affecting all the widgets on the dashboard. This is the script for the action: var dimIndex = payload.data.selectVal - 1; var dimToSwapTo = payload.widget.metadata.panels[1].items[dimIndex].jaql; var widgetIds = payload.data.widgetToModify; payload.widget.dashboard.widgets.$$widgets .filter(i => widgetIds.includes(i.oid)) .forEach(function (widget) { if (widget.metadata.panels[1].$$widget.type == 'indicator') { widget.metadata.panels[0].items[0].jaql = dimToSwapTo; } else { widget.metadata.panels[1].items[0].jaql = dimToSwapTo; } widget.changesMade('plugin-BloX', 'metadata'); widget.refresh(); }) I am not sure if this is the correct Action script since this is used from: https://community.sisense.com/kb/blox/changing-measures-in-the-entire-dashboard-using-blox-user-interface/8802Solved94Views0likes6CommentsDashboard not auto-refreshing for mobile app performance data
Hi everyone, I’m using Sisense to track performance metrics from my mobile entertainment app — like daily active users, watch duration, and session time. Lately, I’ve noticed that some dashboards don’t refresh automatically, and I have to manually reload them to see updated results. I’ve already checked the data connector and refresh schedule, but everything looks fine there. Could this delay be due to caching, or maybe a dashboard setting I’m missing? Would appreciate any suggestions or settings to look into — thanks in advance!37Views1like2CommentsQuerying Model in Text Widgets?
Hi DRay Liliia_DevX Is it possible to query your model in a text widget to display a value? For example say I have a text widget that says Total Revenue: {Total Revenue} this part coming from your model? I know this can be achieved in BloX but BloX does not work with Compose SDK so I am trying to see if this works in a text widget.Solved93Views1like5CommentsDashboard Design Guard - A plugin for enforcing dashboard best practices and organizational standards
The Dashboard Design Guard plugin enforces dashboard design best practices and organizational policies by placing configurable guardrails directly into the dashboard creation experience.448Views1like6Comments