custom queries in widgets
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 fields that sisense can't do, i.e. I need to do some complex window functions so they dynamically update as the user moves around the date range. Thank you in advance1.4KViews0likes2Comments
Horizontal Contribution
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 getting the contribution per Column, this is something I don't need at this time, what I actually need is the contribution per row, is there anything I can do using only formulas or would I need a custom code table on the cube? Thank you all.Solved1.5KViews0likes2Comments
Dynamic (WTD, prior WTD) based on selected Date Filter
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) total, MTD (Feb 1-19) total, QTD (Jan 1 - Feb 19) total, YTD (Jan 1 - Feb 19) for now. I'm currently using the Max Date filter measure for these, however, I can't figure out yet how to show the prior WTD, MTD, QTD, YTD numbers. I attempted to use PASTWEEK(), etc. but there should be an active filter for the week itself before it works. Am I missing something? While if I use the This Week, vs Last Week filter, that would only show the current week and prior current week, and is not dynamic if I change the Date Filter. adding a sample here data here for reference, if user filters January 2024, they should see the latest WTD for January, then it will be compared to the previous week total. Any thoughts, suggestions, tips or workaround would be greatly appreciated 🙂839Views0likes1Comment
Transferring Grand Total from Pivot when converting widget to Indicator?
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. However, this widget needs to be an indicator, and I'm noticing that the grand total does not come through when changing from pivot to indicator. Instead, the Indicator total is displayed as "1". Choosing the option "Running sum by category" also displays a 1. Is there a way around this? ThanksSolved1.7KViews0likes2Commentslooking to create a custom Dashboard filter from a result from another widget (Live Data Model)
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 Sisense interface (Dashboards, Widgets, formulas, etc.), I am not a coder whatsoever. Please see the link for details: https://vimeo.com/909839916?share=copy Thank you in advance!Solved2.2KViews0likes4CommentsNeed to change the filter colors when something is selected
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-tag').css('color','white'); as filter colors and backgroundSolved3.3KViews0likes7CommentsTabber Automatic Switching
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?Solved2.6KViews0likes5Comments
Pivot Table: Hide Row based on count
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 ABC have been taken then continue to display as normal. I attached a picture for reference, I only want do show the highlighted row. Any ideas?1.8KViews0likes2Comments
Sorting Bug in Pivot Table
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. Anyone else have this bug? Is there a setting I've changed which is causing this? Other pivot tables in my instance work just fine.1.7KViews0likes1Comment
