AssafHanina
Sisense Employee
Joined 3 years ago
User Profile
User Widgets
Contributions
Re: Change colour of the entire report if the base size goes below a certain value
Hey BalaR , Changing the color of the entire dashboard is possible, but it doesn't need to be done from every widget. The goal is to trigger an alert whenever the metric falls below 100, even if the user can't visibly see the value. The following can be achieved with few ways, here is an example: Using Widget script that check for the Threshold (smaller than 100) and apply the style for the dashboard layout as describe here Using Widget script to pop up an Alert while the value reach to the Threshold - Optional approach Here is the example for threshold less than 5,000. Widget script - to be added into the Gauge widget const helloMessage = "Revenue is lower than 5000 usd"; const threshold = 5000; widget.on("processresult", function(widget, result) { const resultValue = result.result.value.data; console.log("Widget result value:", resultValue); if (resultValue < threshold) { // Optional: Show the hello message alert(helloMessage); // Apply styling to dashboard layout $('.dashboard-layout-column').css('background-color', '#000000'); $('.dashboard-layout-subcell-host').css('padding', '10px'); } else { // set to default layout $('.dashboard-layout-column').css('background-color', '#ffffff'); $('.dashboard-layout-subcell-host').css('padding', '0px'); } }); Initial dashboard - Gauge with Single value for threshold set up Dashboard Layout after Alert pop up - optional: Disclaimer: This is a sample solution designed for a specific use case. It may require customization to fit different scenarios or requirements. fyi DRayRe: Date range comparative analysis
hey HQ_Dev_Prod , thanks for sharing the full details. From the understating, it's not a comparative dashboard where users can filter 2 custom range of Date filters. instead, users would like to filter on a Period meaning, Single date Filter. Assuming using a Revenue as Metric, Users would like to see the KPI for Revenue for the entire period, and break by the Revenue for multiple Dimensions. Additionally, users would like to be able to Review the Growth from the First Period (i.e. Jan) to the Last Period (i.e Jun) in respective to the Date filter. meaning if the range is different (Jan - March) the Growth calculation is Rev(March) / Rev(Jan) For getting this, it's require to use a filter measure (not the plugin) to Get the Minimum and Maximum of Date according to the date Period. Please find an example on behalf of the Sample Retail Datasource: Open the Sample Retail datasource and add Custom Column: Month_year column to Dimdate table as the following calculation: getyear(date) * 100 + getmonth(date) Import the dash file Review the Dashboard Formula related for Min and Max: It's using Top/Bottom 1 to filter the Max(Month_year) Try to apply the same on your side Dashboard Output: Red Present Min Period Green Present Max Period Total Order Revenue relate to the entire period Please note that it's a sample use case and may not work across multiple use case Best regardsRe: Add Support for OR condition between dimensions in Custom Row Level Security Plugin
hey sohail , thanks for submitting the feedback for the product team. Please consider an alternative implementation for Data Security using OR Condition as describe in the following article Best Regards Assaf, Solution ConsultantRe: CASE WHEN syntax w/ multiple conditions
Hey bminehart , in case it's on a widget level, the Syntax seems to be OK, however, it's seems the Case when is apply on string, [column A]='Value', if that's the case, than it's not supported on the dashboard level. | Please find an example Syntax Best RegardsRe: Drill To Buttons
hey HQ_Dev_Prod , The Script Doesn't support it and Natively it's not supported. it might be possible using Script but required additional development and Checks. Additionally, not sure if that's the best user experience to Filter and Drill at the Same time as it's missing the Primary Category. Alternatively, Consider having Blox Action to Add Secondary Dimension which can behave as Drill and can provide more User Experience. Please find a community example for Pivot table. Best Regards
