irismaessen
Data Pipeline
Joined 10-25-2021
User Profile
User Widgets
Contributions
Re: How to Display Category with 0 Values in Bar/Line Chart?
Hi Astroraf, HamzaJ I no longer have access to a Sisense instance, but I've had luck in the past with adding either +0 (or something like it) to my formula, or using, in the formula, a value from the dim table that I need to show all the values from. So something like SUM([Total Emissions]) + Count([Category])-1. Where Count([Category]) will always be 1 in your pivot/bar chart because it's the category you're splitting on.1View0likes0CommentsRe: Selected value in accordion widget is not getting change the parent dashboard filter in Sisense Why?
Hmm.. Linking it directly to a KPI widget is not possible as far as I know but you should be able to arrange the buttons of the tabber widget in such a way that there's a tabber button directly underneath the KPI widget, perhaps? Iris2.3KViews0likes0CommentsRe: Selected value in accordion widget is not getting change the parent dashboard filter in Sisense Why?
Instead of the fold-out of another dashboard that is the Accordion, you might consider using a Tabber instead. Tabber shows/hides widgets on the dashboard itself depending on the selected tab from the widget. Because the widgets are still on the dashboard itself, you can have the filters from widgets inside the tabber affect the main dashboard even if they get hidden afterward.2.5KViews1like0CommentsRe: Share Dashboard folder public
As far as I know, there is a system group 'Everyone' that you can share a dashboard with, and any user of Sisense can then see that dashboard. Even if they weren't a user yet when that dashboard was shared. I don't think that works for Folders, though, other than if you share a dashboard in a folder, other users will also see that dashboard in that folder -- but not the other dashboards unless you've shared those, too.988Views0likes0CommentsRe: Sharable link with Filters enabled
JasmineC I've edited my earlier comment to update the link to the new documentation. What I can't find on that page, and what I can't remember if it was there earlier, is that you can use JSON.stringify(prism.activeDashboard.filters.$$items) in the browser console to get the filters on the current dashboard. This will include a lot of information that is not strictly necessary but it will, of course, also include everything that is. I've usually been fine using the stringified filters directly, but in some cases (eg you have free text filters) it may be necessary to url-encode them. I might also add that depending on the exact Sisense version, this does not interact nicely with PDF exports and/or Accordion dashboards so if you rely on those, test accordingly.1.1KViews0likes0CommentsRe: Sharable link with Filters enabled
There *is* a way to do this -- extract the filter JAQL from the dashboard and add it on to the dashboard url. This is how you can append filters in an embedded iframe dashboard. But getting that JAQL is quite involved and results in a very, very long url if you use a lot of filters. Ophir_Buchman also created an article in the community detailing a 'lighter' way to do this, but it requires adding scripting to the dashboard you want to share (and doesn't work that well for date filters) So yes, it would be nice if there were better, out-of-the-box options for this1.5KViews0likes0CommentsRe: Bigquery can't retrieve data but can see schema due to wrong dataset location
My experiments with BQ were a while ago and I don't remember everything, but I do remember puzzling over this too. In order to get Sisense to retrieve data from the correct BQ location, I had to specify the location in the 'Additional Parameters' of the connection within Sisense; add there something like: location=US (or wherever your data is located). I may also have had to set up an explicit LargeResultDataset (include the name of the dataset in the Additional Parameters in the same way as the location, separated by a semicolon) Iris1.3KViews0likes0CommentsRe: Admin not able to see all dashboards on the Analytics page
The feature where Admins can see all user dashboards can be enabled/disabled from the API. Perhaps it was disabled in the migration process. See also: https://docs.sisense.com/main/SisenseLinux/managing-your-users-dashboards.htm1.6KViews1like0CommentsRe: Can't Export PDF in embedded iframe when filters are applied
We used to have this issue as well in an older version of Sisense but at least in version L2023.4 this was fixed -- sort of. What we now notice there is that _only_ the filters applied on first ( so the programmatic ones) dashboard load are taken into account for the PDF export, not the ones the user themselves set afterwards. Did this get unfixed in more recent versions or are you using an even older version? Iris3.5KViews1like0Comments