Sometimes with a pivot table full of many columns with zero and only a few non-zero values, you want the zeroes to display as empty-string. That way the nonzero values really stand out.(This is the opposite of this: Solved: nulls to 0 in pivot - Si...
Anyone have a thought as to why a widget would show on a PDF preview, but not on the saved PDF file or when printed? The widget does have script to have a resulting value changed to text. Windows based version First snip is the PDF preview, second i...
Hi All,Need Help!!!I want to add a tooltip on hovering on a image (Blox).Thanks
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 ,I am trying to create a check box which will select all the other checkboxes, but somehow its not working.if there is any other solution by using a button that would also work for me. Thanks{"type": "Input.Toggle","title": "Select All","id": "chk...
Hello,I've researched the past discussions for this question and did see that the advised solution was to disable the pivot table's Auto Height setting and adjust the height of the widget until a scroll bar appears for the pivot table, separate from ...
I want to use a simple if statement without using aggregation, just logical. How can I get this to work in an indicator widget:IF([is_pec_broadcast_session] = 'Yes', [# of unique session_id],[# of unique user_id])Simply, If is_pec_broadcast_session e...
Hi,our team enabled shared formulas in DEV and PROD. We create the dashboards in DEV and migrated to PROD. When migrating the PROD we are getting this error. If I edit the widget and go the 'values' section, all the values are empty so I need to re-a...
I want to be able to override the dashboard palette with my own set of colours, without building a custom set that i can just pick from the option at the top of the dashboard.
Hi All, I want add tooltips for all the columns present in a table widget .
Has anyone been able to use the contribution() function in conjunction with PASTYEAR()? in PIVOT2E.g. we have CONTRIBUTION( [ Sales ] ) working fine but attempting CONTRIBUTION( PASTYEAR( [ Sales ] ) ) results in error when adding to a pivot widget.I...
My team and I are currently working on a pivot table where we track how slot machines are performing based on their Stand ID (denoting a location on a floor), based on changes made to machines at that location.The "ChangesPivot_v1" attachment shows o...
Assuming that you have a properly-designed dimensional cube structure, with no many-to-many problems... in your experience, what are the biggest factors that influence total cube size? (And therefore Sisense system performance impact, memory utiliz...
Hii, I have pivot table merchant names and sales , now i want to color the top 3 and bottom 3 of sales column , top 3 should be green and bottom 3 should be red . How can i achieve that
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...
