We're trying to build a formula using CASE WHEN syntax with multiple conditions using AND.Example:CASE WHEN MIN(MNDIFF([time A], [time B])) <= 30 AND [column A]='Value' THEN DUPCOUNT([column B]) ELSE 0This syntax is not working. Any tips?
I have a KPI dashboard using Tabber with 2 tab, FIRST vs EVER. This KPI dashboard also has a Jump To button and the Jump To dashboard has the same 2 tabs, FIRST vs EVER. Is there a way to pass the Tabber selection on the KPI dashboard to the Jump To ...
Hi @DRay @Liliia_DevX ,I am just curious if the attached screenshot can be replicated or made in Sisense? I am trying to show three separate measures within one widget/bar chart.
Hi everyone,I'm working on a widget in Sisense that analyzes driver activity, and I'm trying to calculate the percentage of each driver's total trip time that occurred during their scheduled shift.I have the following fields:shift_alignment – catego...
Hi Everyone,I have a few fact tables that all share the column "registration". In my original build, I created a dim table by just saying:Select Distinct [registration ]from Table1 etcNow that I have other fact tables, is it possible to append all of...
EDIT: Sample data-set attachedHi there, I'm working on a dashboard that needs to accurately filter inventory records based on dbt snapshot dates (dbt_valid_from and dbt_valid_to) in SiSense. I face a similar challenge to another recent user post usin...
Hi Everyone, I am very used to using PowerBI, where one way to create a dimension table, you would duplicate the table you were looking for, choose the column you wanted and then removed duplicates. This was all done in power query.I am now wondering...
Hi all,We've had feedback from customers that the right-click to drilldown behaviour on pivot-tables is not intuitive, especially for non-superuser staff. Our ideal behaviour to make it clearer would be:Row label is blue (and clearly clickable).On cl...
I have a top 10 bar chart where the design options are not functioning. If I change the value label direction, X-axis options, Y-axis options, etc it has no effect at all. There is a script in the widget but has nothing to do with design. This now ap...
Hi I want to show the total task percentage i have a task count which i achieved by dupcount([Student id ]) = 337 i got the total count which is Grand total which i got by grand total option on a task which is 22,315now my formula should show 22,3...
When I select fields in a pivot 2 table for filtering, those fields will be highlighted. If I then hover over additional fields, they get highlighted in the same color, like this:I would like to achieve 2 things in my pivot 2 tables:1. set the hover ...
Hello, I am working with a client's dashboard and trying to get a horizontal scroll bar to appear on a table widget. I have tried this code:dashboard.on('widgetready', (el, args) => { $('.p-mid', 'widget[widgetid=' + args.widget.oid + ']').scroll...
Hi Sisense Community,I'm working on an inventory dashboard in Sisense and I'm using dbt Snapshots to maintain historical inventory data. My snapshot table includes dbt_valid_from and dbt_valid_to columns to track the period for which each inventory r...
Hi Sisense team!Is it possible to add static values to a widget that would allow creation of a visual?For example, in a dashboard showing Thisyear/Lastyear month over month revenue values, how might I add a visual that shows the target revenue values...
I'm having an issue with the widget script to color the labels in a table created by @harikm007 in a previous post. https://community.sisense.com/t5/build-analytics/colored-labels-in-table-widget/m-p/10780I have successfully been able to implement th...
