Interactive Time Period Comparison with BloX & Custom Actions
Here is a use case on how to leverage BloX widgets in Sisense to create an interactive dashboard for comparing any KPI between two different time periods. This solution allows users to select two months (or any two time periods) and dynamically calculates the percentage change in the KPI between these selected months.11KViews3likes4CommentsUsing Native Javascript Date Calculations To Modify Sisense Date Filters
Sisense natively supports various types of date filter functionalities. However, there are instances where a dynamically updating date filter is desired based on dynamically changing conditions such as the current date. Such a filter may not precisely align with the filters provided in the Sisense UI. One approach to achieve this custom behavior of a dynamically updating filter is through the use of dashboard or widget scripting.5.5KViews3likes13CommentsAdd row numbers to pivot rows
We have on a dashboard a pivot with a single row grouping value but many rows and many columns. For the readability of the pivot, I'd like to provide my user with row numbers that don't move when the sorting of the pivot is changed. (So the first row of page 1 always has row number 1) I need both the sorting functionality of a Pivot widget, and to be able to drill/jump using JTD, so I don't think BloX is suitable for this. Is there any way to achieve this?Solved5.2KViews0likes5CommentsSetting default filters through iframe query or disable "reset to default filter option"
Hi team. We are loading the sisense dashboard through an iframe, and we are passing filters as query parameters in the iframe URL as mentioned here https://sisense.dev/guides/embedding/iframe.html#_5-appending-filters We are looking to achieve either of the following: Disable (or hide) the `Restore my default filters" icon on the sisense dashboard when loaded through an iframe. I'm able to disable "set as a default option" as per this post https://community.sisense.com/t5/build-analytics/disable-dashboard-default-filter-settings/m-p/2017 by using the "Edit script" option in the sisense dashboard. Do we have a similar way to hide the highlighted icon? If it is not possible, can we read filters passed from the iframe query in "Edit script" and set those filters as default filter instead?Solved4.1KViews0likes4CommentsReplacin 'NULL' with '0' in in calculations for column chart and pivot table
Hi all, For a culumn chart I calculated averages and divided the percentages into segments, the percentages do not add up to 100% After some searching I found out that this is because the 'NULL' values are not seen as '0' and therefore the calculation is not performed properly. See the pivot table below, for this pivot table I want to replace the null values with '0'. As can be seen in the updated table, it can be seen that the table generates null values but does not include them in the calculation of averages. I've already tried to solve this using IFs , but without success.Solved4KViews0likes4Comments