Calculate the Average for the indicator as on the pivot with the filter
Learn how to accurately calculate the average value for your indicator widget using the AVG formula. This guide highlights how to achieve consistent results, even when applying filters for Marks. Discover the correct formula— avg([student], [Average mark]) —to ensure you get the expected outcomes, with [student] representing all items and [Average mark] reflecting the average of Mark values. Perfect for data analysts seeking reliable insights!Selectively Hide Widget Toolbar Buttons
Selectively Hide Widget Toolbar Buttons The widget script below shows a list of buttons that are available on a widget toolbar and how to hide each of them, so you can choose which ones you want to hide for any particular widget. Note that if you hide the Edit button, as the owner of the dashboard, the only way for you to open and edit the widget is to have the direct URL to the widget. If you want to hide the button(s) only for viewers (so you can still see all the buttons as the owner/designer), uncomment the code that checks the user's role (see comments in the code below). /** This is the widget script to selectively hide widget toolbar buttons **/ //Hide widget toolbar options widget.on('buildquery', ()=> { //Uncomment the code below if you want to hide the buttons only for viewers //if(prism.user.roleName == 'consumer') { //Hide Edit (pencil) button $(element).parent().find('.widget-toolbar-btn--edit').remove(); //Hide Expand / Full Screen (diagonal double-headed arrow) button $(element).parent().find('.widget-toolbar-btn--fullscreen').remove(); //Hide Detail (circled i) button $(element).parent().find('.btn--no-background').remove(); //Hide Menu (vertical ellipsis) button $(element).parent().find('.widget-toolbar-btn--menu').remove(); //Hide Analyze It (graduation owl) button $(element).parent().find('.analyze-it-button').remove(); //Uncomment the closing curly bracket below if you want to hide the buttons only for viewers //} })
