I have a need to filter based on day of week - for example, I need to total all weekend (or weekday) sales.The filter would seem to be the way to go, but I can't find a way to get it to filter based on weekday. I tried JAQL exclude, which it parsed o...
Hello All,Is there a way to customize "No Results" layout, we have few buttons at the top being hidden when widget has no data. Also adding the html script we're using. TIA const dropdownWrapperHTML = `<div class="dropdown-wrapper-${w.oid} ${dimnam...
We want to be able to disable jump to dashboard for certain rows in a pivot table and bars/pie-slices in various charts. Currently we are only able to disable it completely. We would like to be able to be more specific on the disabling and only remov...
Creating a new post as I cannot comment on this post - https://community.sisense.com/t5/build-analytics/hide-widgets-based-on-selected-filters/m-p/5375I am using the widget script that the above post from @harikm007 to hide widgets based on selected ...
I have a dashboard where one of the dashboard-level filters is for a date field that's filtering down to "Last Quarter"Is there a way I can have the exact date range for this value displayed somewhere within the dashboard itself? I know users can see...
There was a forum post a long while back about avoiding having to create formulas that add up PREV(1) + PREV(2) + ... + PREV(N) periods to get a rolling average or sum. I can't find it now but it referenced an undocumented function for rolling previo...
Hi all!I'm relatively new to Sisense & just finding my way. I've followed the instructions in this post about adding a Target or Benchmark line to a chart (https://www.binextlevel.com/post/add-target-benchmark-line-to-a-chart-in-sisense).However, I'v...
Hello! I'm trying to figure out if it's possible to filter a given field based on the character length of its value. This is for a clean-up project. In my case, I'm trying to find records where the "Matter Name" field is below a certain number of cha...
Hi SisenseWe would like to change the ownership of a datamodel (built on live connection) from user 1 to user 2. Can someone share the process?
Hello,Is there a way to bring a chart forward/backward in a dual axis chart? I would like to bring the lines on the below chart forward... Also, glad if there's a way to customize the fonts (size/color) for the Value labels and/or Axis labels.Thanks...
I want to show individual records that exist in a month. Pivot seems only able to aggregate, table i can't define columns:So here, i would wan tthe 1 record to show the Name of hte record, if there's 4 records i would want 4 rows, or the 4 names at l...
I need to display a date/time in the pivot. I've managed this via widget script, but that makes conditionally formatting virtually impossible, as the date is not really a date (i need to colour them based on how old the record is, so i can't simply s...
If you find it challenging to locate which filters are currently applied in your Sisense dashboard due to a high number of options, you're not alone. Scrolling through the filter panel can be cumbersome. A great solution is to add a widget that displ...
We are embedding a Pivot Table dashboard using Sisense.js and the pivot table needs to be filtered specific to the user that's viewing the data. We did figure out how to filter the table using a jaql query, but that Jaql only seems to work with an iF...
Hi TeamI am trying to find out a doc that can explain how JWT token works with iframe?If there is any code snippet to generate JWT token exists somewhere, please let me know as well
