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...
Hi SiSense Community,I'm currently working on multiple instances (dev and test), where all the changes to the asset are made only in the dev instance in the same branch.When I go to the same branch in the test instance, and hit refresh, for some reas...
We're considering a setup with many tenants. What overhead (RAM/CPU) is there for each additional tenant?Have others tried working with many tenants (20+)? Did you run into issues?(I want to know because, depending how we do it, we might have lots of...
Is it possible to turn off the moving of the tables in the Elasticubes? When I duplicate one the tables/circles all move around for a few seconds. Is it possible to turn this feature off?
Hello,When we setup a git project in sisense, it asks us to enter the credentials (username and PAT token), so since the PAT token is associated to a 'dedicated user' and not on the repository level, are there any best practises on managing this secr...
I have a Git enabled project (say named 'Project A') in which it's always connected to 'main' branch. Knowing the current constraints:A project can only have one active branch.Each asset can only be assigned to one project.Each asset can only have on...
In my table, each record has a date range denoted by two fields. I would like the user to be able to use a date filter to select any day within the range and have that record be selected.Example:Pointing to this four-field table, the user could choo...
Hi Everyone,I have my data in S3 buckets and this data refreshes once in a day. So, For me Live connection datamodel under Sisense doesn't make sense because unnecessarily for every dashboard load-- query will run (either in Athena or Redshift) which...
Hello,I am currently using the following widget script for a pivot using rows (no values or columns) on windows OS:widget.transformPivot({}, function(metadata, cell) { if (cell.value == 'Resolved') { cell.style = { ...
Hello Everyone, I am trying to use Switchable Dimensions on a line chart with a datetime table. The objective is to switch from yearly, monthly, and quarterly timeframes using switchable dimensions. In Sisense's documentation, they give an example th...
