Limiting Date Range Filters in Sisense Dashboards
Wide date ranges in Sisense dashboards can lead to performance issues, especially when using live models or querying large datasets. For live data models, large queries increase costs as more data is pulled from the data warehouse. For Elasticubes, this can cause performance bottlenecks. To avoid these issues, here is a quick solution to "limit" the date range users can select, ensuring both cost-efficiency and smooth performance. Read more to find out how!Financial Formatting for Pivot Tables on Linux
Question How to apply Financial Formatting to Pivot Tables? Answer Financial reports usually have specific styling requirements where negative numbers are shown in parentheses as opposed to having a leading minus sign. They are also usually written in red. The script below formats all the negative numbers in pivot tables exactly as the requirements above. Feel free to modify it if you have different formatting requirements. // Format negative numbers widget.transformPivot({ type: ['value'] }, function(metadata, cell) { if(cell.value >= 0 || !cell.value) { cell.content = cell.value; cell.contentType = 'html'; } else { cell.content ='(' + (-1*cell.value).toString() + ')'; cell.style.color = 'red'; cell.contentType = 'html'; } });
