Hi All,I need help!!!I want to navigate from the values in pivot table to another dashboard and filtering the selected value in that dashboard.Eg.NameIDSalaryA1231000B4562000C4322300I want to select ID and navigate to dashboard 2 with selected ID fil...
To add dynamic count Count([id]) to the widget, I just simply type {panel:Count} (screenshot 1). For complex Sisense function (please see my screenshot 2 below) like this one: avg(DDiff([Days in effective_end_date],[Days in effective_start_date])), e...
Hi,I've built a drop-down list with customized values; please see below: "type": "Input.ChoiceSet","id": "data.filters[0].filterJaql.members[0]","class": "","value": "","displayType": "compact","choices": [{"title": "Rule 1 - Unauthorized expense for...
Hi All,I wan to to have dashboard(not widget) border for my dashboard, an outline for the dashboard.if you can also help in fixing the size(height & width) of the dashboardThanksExample : black border
Please reference the attached excel worksheet. My goal is to show all horizontal categories, even when data = null/0/N/A. Currently, only 3/6 categories appear and I've tried nearly every Sisense KB article I can find related to null/N/A values. ...
Hello,I need clarity on the lowest Sisense role needed to 'CREATE' new notebooks. Not just view, edit and own.The user guide (https://docs.sisense.com/main/SisenseLinux/sisense-user-roles.htm) says 'Data Designers' can, but someone has a hunch that i...
I have found this post that shows how to select a default tabber option programatically:https://community.sisense.com/t5/build-analytics/default-tabber-selection/m-p/2345However, this manually displays and hides whatever widget you want and highlight...
Hi,I'm computing for change in metrics from period to period. For example, what's the pct change in sales from 2022 to 2023. Question 1: If data is only available until March 23 2023, will Growth functions compare 2023 data with 2022 data only until ...
Hi everyone, I am trying to create a running sum formula in a Pivot table. The formula is RSUM([Total net revenue )]).When I have 1 dimension in the Pivot table (item number), the formula works as expected.However, when I add more fields (item name, ...
Hello, fellow Sisense UsersI'm trying to create an indicator widget that shows the number of unique email addresses in a dataset ONLY when there are 5 or more records with that email address AFTER the dashboard's date range filter is applied.Example:...
Hello,I have a basic requirement but I am not sure how to implement it.My dashboard shows sales by a filtered time frame (can be Month, Quarter OR year).To the Total Sales widget (attached below) I would like to add, on the secondary measure, the Ye...
For a Polar Chart Type I need to specify the order for the category values - there is no facility in the design panel to do this. I am not able to change the data to add numbers at the start of the categories.Is there a way to order the category valu...
Hi all, I'm new to Sisense but not new to BI. I'm trying to put together some auditing on cube builds, ie. which cube, when, success or fail, build time. We running version 20.22.9 in Windows. I've found the logs but can't anything specific to bui...
I'm encountering an issue despite inputting the correct data; the Speakatoo API is not operating as anticipated for me.
When creating a column chart you'd sometimes want to reorder the category fields Apply the following widget script: widget.on('processresult', function(widget,result) { // Wanted Order let order = ['New','Used','Refurbished','Unspecified'] // For ...
![83227784_3726975083979609_8570336295451099136_n[1].jpg](/t5/image/serverpage/image-id/602i3D789947CB5B424B/image-size/medium/is-moderation-mode/true?v=v2&px=400)
