Hi all, I am using this formula to flag a 1 for every project that is at or under budget. SUM(CASE WHEN ([Total budget] - [Total amount]) >= 0 THEN 1 ELSE 0 END)This works fine as a pivot table since there is an option to display a grand total. Howev...
Our company uses user groups to contain users based on their employer and the dashboard packages they should have access to. In order to not overcomplicate the administration process of adding and removing users, I'd like to find a way to make member...
Hello!I have a widget in a dashboard that shows the number of subscribers for my app week over week and year over year. My data's grain is daily per subscription plan per platform. For example, if we have 10,000 subscribers, then the data looks lik...
HiCurrently I have an created dashboard which takes data from Bigquery. I am planning to add RLS(row-level-security) policies to Bigquery tables so that data belonged to particular user/tenant can only be shown. How can I update my dashboard or data-...
When logged in as admin, I am not seeing all of the dashboards created. Another user sent me a screenshot of dashboards she is seeing, but I do not see them. Is there a filter limit on the amount of dashboards displayed? Also, we did convert from ...
Hi All,We are using single deployment Sisense on v1 module . I need to pull widget JAQL TO SQL , but SQL Analyser is not available.Please suggest ways to pull SQL queries based on JAQL of widget Thanks
I want a table or pivot table but the cells are full size blocks/tiles that effectively look like this:The number will be a calculated function ddiff(date, now) but the text "days" needs to appear, the cell should be a box etc.. Is this something i e...
I want to set specific colors for the bars in my bar chart by dimension or category. I do not want to use break by because some values aren't in the data yet. How do I achieve this in edit script?
I attempted to create a data bar representing a scale of 100, but the output is incorrect.There the output:
I want to create a bar chart. Under Categories would be "Common Term", which is dropdown field that has close to 300 distinct options a user can select. The size of each bar would be the number of Matters that contain each Common Term. The problem is...
How to set an interval on X-axis for a continuous timeline so that the labels don't look so crowded? I want to show less labels on the X-axis and be able to control the interval.
May I know what is the dashboard layout library being used in sisense dashboard ui? I’m currently developing dashboard in my application, it should get dashboard and widgets from sisense rest api and position it in the web application. I’m using grid...
Hi all, I want to make bubble chart inside the Pivot table, we have column as a Category and rows as an ID, I want to show bubble as a value between them. Please help. Thanks
Hi, I am trying to adjust my script so the black background continues to be black even when "No Results" are shown. Right now, I have a dashboard that has black background with white text, but the charts the don't yield any data at certain times reve...
Hi all, We created custom code in one of our elasticubes. However, after a week it fails, usually with the following error: "timestamp": "2022-05-24T06:00:31.697Z","verbosity": "Error","type": "buildEnded","message": "Failed to build custom code tab...
