How do you handle timezone conversions on dashboards?
We store our dates in UTC format and want the ability for dashboard viewers to view the date data in their timezone, or in a timezone they select. Has anyone figured out a way to do this? We have a LOT of date data in our data model.Solved7.2KViews0likes5Comments
How 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.4KViews1like2CommentsScheduled Build Not Building Table Changes
I have a scheduled build for my Elasticube each morning. The build behavior setting is set to "Replace All" on every table. When I make a change to a table the changes are not being built, new data is being imported but my new columns or where clause changes are not being applied. Also the table still has the triangle play button at the top left of the circle signaling that changes have been made. If I manually build with Replace All or Changes Only then the changes will be applied but I would like for the changes to be made each night when the Elasticube is pulling new data.Solved2.3KViews1like3Comments
Empty filter at initial load in Linux version?
Has anyone discovered a way to make a single select text filter load "empty" by default? This used to be possible in the Windows version, but now that we have migrated to Linux, we have lost that ability. Use case...we have created dashboards that are deployed and used by different clients (in this case, we display academic data, so our clients filter their dashboards by "Term"). However, our clients all name their terms differently...so we can't set a default value. In Windows you could remove the default value in the .dash file, and then the filter would load empty, therefore making the client choose a value to display data. In Linux, that now causes the dashboard to load ALL Term values....even on a single select filter. This can be an overwhelming amount of data, and cause timeouts. Has anyone solved this type of issue in the Linux versions? Thanks for any pointers.2KViews2likes2CommentsStandalone Installer
Good Afternoon Sisense Community, Is there a standalone installer for sisense that we can utilize to install the initial product on our cloud instance? We are getting reports that we will have to allow or whitelist specific URL's to our environment, but are having issues doing so. Do we know if there is an .exe or .msi package that we can utilize?2KViews0likes2Comments
Modify role permissions on a user duplicated dashboard
Any thoughts on modifying the role permissions on a duplicated dashboard? Per documentation - we could enable/disable the permissions at a dashboard level (ex: disabling widget edit capability), but when a dashboard is duplicated - the user is able to still edit widgets. We understand that a user becomes the owner of the dashboard once duplicated, but we still want to restrict some specific actions the user can do. any thoughts on how to edit the role permissions via the API to achieve this?1.8KViews0likes1Commentunexpected N\A from PERCENTILE function
We sometimes received N\A results from a PERCENTILE calculation, even though with the same dataset we will get results from other statistical functions like AVG or MEDIAN. I'm wondering if this has to do with a minimum number of values requires to calculate PERCENTILE? Is this defined anywhere? I don't see it in the online function reference. Is there some other common cause for getting an N\A result for PERCENTILE?1.7KViews1like2Comments
