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
Hi Community,I have unhidden a previously hidden column in my elastic model.When I go to designer mode, the column is still not showing up for me to pick.Is there something else I have to do?Thank you
I want to utilize the Usage Analytics Dashboard that will give me these key insights/KPIs: MetricDescriptionViews per dayTotal number of views per day per dashboard Views per userNumber of views in the past 365 days, broken down by individual users.T...
I'm looking for ways to hide certain dashboard filters based on their title name. Is there a way to do the same? Also, the filters will be added as dependent. For e.g. we can have these 4 dependent filters Filter1 >> Filter2 >> Filter_3 >> Filter4 an...
I've failed at this for so long I'm finally going to ask for other sets of eyes to confirm my finding or to out-think me and solve it. I don't think it can be done but it would be so powerful for some many of my clients if we could sort it out.The sc...
I would like to implement a filter on the dashboard that enables users to filter widgets. How can I achieve this using JavaScript without relying on plugins?For example: Filter Name: Widget Filter Filter Values: A, B, C Widgets: A', B', C'When the va...
