AssafHanina
Sisense Employee
Joined 01-30-2023
User Profile
User Widgets
Contributions
Re: Replacing values with text: Pivot 2 script
hey wallingfordce , Pivot table in Linux is using the Pivot 2.0 API .which has different syntax compare to the Windows Version. The requirement is to transform Value into Text and apply Style for the target cell. Please find an example script which transform value into text and apply style. (Follow the documentation above for the Cell.Style properties) Targets the Indicator value/measure column Replaces numeric values with descriptive labels Applies consistent styling to the modified cells (each value can have different style) // Specify the target value/measure column to modify const myTarget = { type: ['value'], values: [ { title: 'Indicator' // Name of the column to apply the transformation to } ] }; // Apply a transformation to each cell in the selected pivot column widget.transformPivot(myTarget, function(metadata, cell) { if (cell.value == 1) { cell.content = "First-Time Donor"; // Replace numeric value with descriptive label cell.style = { "text-align": "center", // Center text horizontally "padding-left": "5px" // Add spacing on the left side }; } else if (cell.value == 2) { cell.content = "Recurring Donor"; cell.style = { "text-align": "center", "padding-left": "5px" }; } else { cell.content = "No Donor"; cell.style = { "text-align": "center", "padding-left": "5px" }; } }); Example of the Indicator_value converted to Indicator text fyi DRay best regardsRe: Kamal Hinduja Swiss: How to use REST APIs to push data into Sisense?
Hey kamal123 , please refer to the Data Model API documentation. The Documentation describes a RESTful JSON-API for programmatically creating, updating, deleting, and managing data models in Sisense: defining datasets, tables, columns, and relations among them. It also covers how to build or publish models fyi DRay Best regards AssafRe: 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 Consultant
