I have a very simple ask. When I go into widgets I am able to click on the three dots and hit Analyze SQL Query but I don't see a way to edit it. I would like to be able to edit the query, is there a way to do that? I need to create custom calculated...
Hi Sisense Devs,I'm using a Pivot Table Visual in which Im using employee_name as my rows, phone state as columns (With over 15 categories), phone state duration as values, I converted the values to % using the CONTRIBUTION formula on Sisense, but Im...
Good Morning Enthusiasts!We have a client requirement to present WTD, MTD, QTD, YTD numbers that would be dynamic depending on the selected/active Date Filter.Example, if current filter is year 2024, they should see the latest:WTD (as of Feb 19) tota...
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...
Dear Sisense Community,I am looking to see if there is a way through scripting that I can use the values from a Pivot table (one column of text data) to create a custom (Advanced) filter for the Dashboard.By the way, although I'm capable with the Sis...
Hello All, I am creating a dashboard that is displayed on a TV monitor and someone will not be able to manually click between the tabs. Has anyone had success creating a script that would switch between the two tabs automatically every 30 seconds?
Hi All,I have several filters in my dashboard, i want to change the colors when something is selected in the filters to distinguish between selected and unselected filters . currently i am using $('.uc-tag').css('background-color','#006ecf');$('.uc-t...
I have a pivot table listing out test taken. Currently it list all test taken but I only want to show the row if all three test have been taken. So if test A and test C have been completed but not test B then that persons data would be removed. If AB...
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
I'm getting an odd bug in Fusion Pivot tables where columns will not sort (except first column which /can/ sort). The first column (a list of the names of various schools) will sort just fine ASC and DESC. For any other column sorting has no effect. ...
I have a Blox dropdown filter that is one selection at a time. I would like to make it multi select but the only link I can find is here: https://community.sisense.com/t5/knowledge/multi-select-dropdown-list-filter/ta-p/9595Is there a way to make the...
I Have the following measure that i'm trying to get to work.RPAVG( (((([# of unique EntityReference],[DangerousOccuranceType_id])) +( ([# of unique Level1]) - ([# of unique Level1]))) *200000) / ( ([Employee Hours]) + ([Agency Hours]) + ([Contractor ...
I have the following code, but it is only searching on the second filter and not the first. { "style": "", "script": "", "title": "", "titleStyle": [ { "backgroundColor": "#093e52", "backgroundImage": "", "fontColor": "#093e52" } ], "showCarousel": t...
I was creating a dashboard for someone, and one of the widgets was a column chart that plotted out the number of people per year of hire. So, x-axis is the year of hire from left-to-right, then each column is the number of people who were hired that ...
I want to hide a column until the user drills into the chart. Example of what it currently looks like below: I would like to hide the "Videos in Module" until the user clicks the drill into. So it would look like this initially. Then when a user clic...
