Hello. I am trying to calculate the average of my 2022 and 2023 unit totals. This metric is calculated by doing a DUPCOUNT([AccountId]) in my widget. Yes, I am using the dupcount on purpose. I tried making a custom column to calculate the totals for ...
Hello everyone,Hope you are doing well.I have reviewed the content available on Sisense Academy, and it appears to be good and informative. However, I am currently seeking hands-on training materials for ETL workflow, Elasticube modelling, and dashbo...
Hello,I had an earlier challenge which was solved by Daniel (@rapidbisupport). Thank you!Now, I'm hoping to take this one step further. After the Dashboard filter has been created, I'd like to create another BLOX button to remove specific filter entr...
Hi all,So I am running the following script on my widget (using 'edit script') in order to grab the date of the maximum dollars for a year using a different bar chart widget on the dashboard, and display that date (along with the $ amount) on an indi...
Introduction:Managing plugins in Sisense, particularly in scenarios where multiple plugins need to be updated or reverted, can be a time-consuming task. However, by leveraging bash scripting, this process can be automated to save time and ensure cons...
I want to get a rolling sum for 12 months broken by each month. In past community posts it was mentioned to use a function "RPSUM". could not find this function is this function deprecated now?https://community.sisense.com/t5/knowledge/rolling-traili...
Hi,I am trying to play with NLQ features and noticed that it only includes attributes that are part of the dashboard and does not consider the one from the underlying model, which really limit the scope for our end users.Is there a way we can include...
Hello,We recently upgraded our Sisense installation from version L2022.3.0.235 to L2023.9.0.297. We are using a LIVE data model that is connected to Snowflake. One feature we noticed has changed was the ability to filter dashboard widgets on time co...
Trying to find a way to reload the dashboard completely after the filters are changed. Some of the functionality in my dashboard is lost when I change the filters so would like to completely reload after the filters are changed. The below code was wh...
Hello,I would like to create a custom measure on Sisense dashboard that can do the same this SQL is doingSELECT COALESCE(SUM(CASE WHEN channel = 'Email' AND message_event_type = 'Dispatched' THEN count_of_engagement ELSE 0 E...
Hi there, I have a BLOX widget that I'm using as a controller for a line chart on my dashboard.This BLOX widget is used to change the date granularity as well as change which KPI's are displayed in the below line chart. At a baseline, it works, but I...
Hi is it possible to create sankey chart in sisense as this chart option is not available, i am aware of plugins , but instead of plugins is there a way around to create it using any codes etc.@DRay
I'm trying to insert a custom color. After entering the hexadecimal value, how do I get the functionality to accept my value? <Enter> does nothing. I've tried with and without the # sign.
I simply have a pivot table where the first column contains a varchar and the last column contains grand totals. All columns in between are monthly totals. I would like to add columns in between the monthly total columns showing the difference betw...
We are using Shared Formulas on Sisense and we would like to know how do we move our dashboards along-with Shared Formulas from one environment to another environment. This is my situation: 1. I have a dashboard in DEV, where I created the shared for...
