Resolved! Sum for new date
Hello,Does someone know if in the reporting there is an fx that can calculate an new date, so as I can make in excel =date(today + 21 days) = 21-june-2024is that possible can someone help me?
Forum Posts
Resolved! Switchable Break By Plugin/Widget/Script
I have a Bar Chart that is Revenue per past 12 months. I have 5-6 different fields that my users want to view revenue over the past 12 month “Broken by” or “categoried” by Meaning, lets try a stacked area chart, or a column chart etc… they want the ...
Drill To Buttons
our userss have complained that having to teach people how to right click and find the drill feature, they'd instead like a button at the top of the visual where they can click and it applies the drill function. i'm sure there is a jaql query or impl...
Resolved! Horizontal scroll on Table Widget
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...
Resolved! Sunburst Chart issue
Hello everyone,I want to use a Sunburst widget in order to show a breakdown based on 2 dimensions.What we realized is that Sunburst is not clickable when enabling "Widget affects dashboard filters".Has anyone managed to use it and make it clickable? ...
User/Group table - Data Security
Is there a way to grab a table of all the users per groups that have been set-up in Data Security?
Resolved! Adding custom messages to the standard Sisense Login Page?
Hello,We are hoping to be able to add messages to users on our standard Sisense Login Page. Anything from reminding people about a new feature, to telling them about all the services our company offers (we host on behalf of other customers, but most...
Resolved! Wrong SSO User with Cloud Sisense & Iframed Dashboards
I am trying to find the best solution for a problem at a new job. We use Sisense Cloud (linux) and use iframes to display dashboards from it on a Wordpress site.Sisense is under one subdomain on our main domain, Wordpress on another.Our PCs are share...
Resolved! Dynamic ElasticCubes config for many\multiple dashboards
Is it possible to configure Dynamic ElasticCubes for several dashboards at once? We currently have a very long, repetitive config file and it is getting difficult to maintain. For example, if we could change this to allow a list of dashboard names o...
Resolved! How to include subtotals in download to Excel
I have a pivot table widget with subtotals enabled for 2 rows. The file generated using Download to Excel only includes the first row's subtotals. The subtotals for the secondary row enabled with subtotals are not included in the excel file. All info...
Resolved! SUM based on Text Criteria
I have a STRING column called Question, this question column provides two possible answeres, either 'Yes; or 'No'How do I create formulas to sum the amount of times a Yes shows up, the amount of times a No shows up and the amount of times that both o...
Resolved! Migrate users from one tenant to another
I want to migrate users from one tenant to another; I exported the first tenant users as well as their related data, then I deleted the users so I can recreate those users in the second tenant, I tried to use the REST API tool to add a new user, how...
Flowiseai + Sisense = RAG from a dashboard (all widgets chart data value of a dashboard)
In the previous post, I showed how to use the Sisense Rest-API to get the data values of a specific widget and RAG them through the LLM. (ref https://community.sisense.com/t5/help-and-how-to/flowiseai-sisense-rag-from-widget-data-values/m-p/21591#M25...
Flowiseai + Sisense = RAG from a widget data values
flowiseai : https://flowiseai.com/ flowiseai git : https://github.com/FlowiseAI/Flowise Leveraging flowiseai's LLM workflow, I created a custom tool and node.js-based fetch api code to enable augmented analysis and easy querying of data values for Si...
Transforming Values on Sisense - 1/0 to Yes/No
Hi, I am writing this post to enquire if it is possible to transform data on Sisense at a dashboard level.I currently have boolean fields that display as 1 or 0 - is there any function/script that can be ran on a dashboard or widget to change these f...
