Check out our most popular conversations happening right now!
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, Related about multitenants, we are unable to: - Execute Custom Code in an EC inside a Tenant - Acces the file system from an EC in a tenant so refer with BloX to assets is a nightmare (image icons etc.). - GIT - Look&Feel And more There are other...
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...
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,My data is in an Object in a column. I want to use that data to showcase in the Line chart. Currently I am using compose SDK to create a Line chart. Could anyone can help me to extract that data?Column looks like this: {"sales": [1570.73, 1020.58]...
Some of our users asked for "lock the top widget (with scrolling the rest widgets)" functionality. Is it possible to add it in Sisense in near future?
Currently we cannot granularly control the label names or remove them when using the export modification plugin. The refresh time label is aligned with Sisense data refresh time instead of our internal refresh time. This changes the value that users ...
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...
In a galaxy not so far away… it's almost Star Wars Day! Whether you're Team Jedi, rolling with the Rebels, or secretly rooting for the Dark Side (we won't tell ), we want to celebrate with YOU. Join the fun: Drop your favorite Star Wars meme in the...
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...
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,This is probably a really easy fix but I have columns in my table called Shift Date, Shift Start timeI want to combine these as a custom column and then convert to a date time, but for the life of me I cannot get it to work. They are both text at ...
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...
Data, Drive, and a Dash of Awesome: Liliia Romanchuk in the Spotlight We’re excited to feature Liliia Romanchuk, Support Manager for the DevEx team at Sisense, as our latest Community Champion! With o...
Data Prep Essentials for AI-Driven Analytics - Part 3 This is Part 3 of a multi-part series about Data Preparation for AI-driven Analytics. We can agree that it's been said enough that data quality is...
Driving Sales and Cutting Losses: How MPP Uses Sisense for Smarter Decisions In my previous blog, I shared how MPP’s adoption of Sisense transformed our reporting processes, bringing clarity and consi...
Empowering Women in Tech: A Q&A with Aysha, CIO & CISO of Treasure Data At Sisense, we celebrate the women who are redefining leadership in technology and paving the way for a more inclusive future. A...
