kwmacd
Cloud Apps
Joined 4 years ago
User Profile
User Widgets
Contributions
Indicator Widget Custom Formula: Count unique where 5 or more exist
Hello, fellow Sisense Users I'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: My data source shows "lesson completions" where each record is one completion, with a user_email, lesson_name, and completion_date. The dashboard has a date range filter. I want my indicator widget to count the number of unique user_emails ONLY when 5 or more "lesson completions" exist in the filtered date range. Any sort of help is greatly appreciated1.7KViews0likes1CommentHow to allow users to download a table with 300+ columns
I have been given a SQL query that has a column for each day of the year, and about 50 rows with different business metrics. I have also been told that I need to host this query in Sisense for users to download the data. Given the restrictions on table widgets, how should I best go about serving up this data? Currently, I have the query stored in an Elasticube as a table query. Our Sisense subscription also includes the Report Manager add-on. Thanks in advance for any help!Solved2.4KViews1like2CommentsLimit dashboard filter functionality for viewers
We have a few dashboards where the displayed data is only valid when a SINGLE ITEM is selected for a filter. We want to have the standard dashboard filters that our users are used to, but we want to prevent them from selecting more than one item at a time. In the attached image, we want the red highlighted areas to be disabled (not selectable) for non-owners/non-editors of the dashboard. We should be able to publish the dashboard with a default value for the filter and allow them to select a different value, but not multiple values.978Views2likes1CommentRe: How do i disable toggle switch button in filterpane?
Is there a way to do this same sort of thing for the "Edit Filter" window that pops up? I want to disable the "Allow multiselect for lists" toggle, as well as the radio buttons except for the 2nd one where the user selects a filter value3.3KViews0likes0CommentsRe: Transfer ownership of objects (data models, dashboards)
I recently had this issue where a large number of data models were owned by a user who was no longer with the company. I filed a ticket with Sisense Support and they had it fixed by end of day. There's also some good information in this post: Change multiple dashboards owner (sisense.com)2.8KViews2likes0CommentsDisabling the "Allow multiselect for lists" toggle button on filters for dashboard users
We have a dashboard that is set up to expect only 1 value in a specific filter. Is there a way we can force users to only select 1 value instead of being able to toggle on the "Allow multiselect for lists" button? Converting the filter to a BloX filter is out of the question for our use-case.1.1KViews1like0Comments