Calculate the Average for the indicator as on the pivot with the filter To calculate the average value for the indicator and get the same result as in the Pivot, we use the simple AVG formula in both cases and get the correct result. But if we will...
How to pause widgets loadingIf you need to pause the loading of the widgets for some time, you should do the following.Open the dashboard, press edit widget, find three dots in the right corner of the widget, press on them, and choose Edit Script.Pas...
Disable the functionality that allows users to click on the legend in the widget to filter dataIf you want to disable the functionality that allows users to click on the legend in the widget to filter data.Please use this solution. Open your dashboar...
Analyze SQL Query vs Visualize JAQLQuestion: What is the "Analyze SQL Query" section of the widget for? I can see its SQL however there are no recommendations or visualizations to show the execution or how to improve the query.There used to be a visu...
Selectively Hide Widget Toolbar ButtonsThe 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 ...
To display a solid line on the chart without using the "Display missing values as zeros" functionSometimes there is a need to display a solid line on the chart without using the "Display missing values as zeros" function. Here is a widget script that...
How to represent negative numbers with leading and trailing parenthesesIn Accounting, it is common to represent negative numbers with leading and trailing parentheses.For example, negative two hundred is displayed as "(200)"Also, It incorporates a th...
Leveraging Usage Analytics for Determining Heavy Widgets In this article, we can find a suggested approach on how to determine dashboard widgets that consume a lot of memory and may cause performance issues. Usage Analytics Usage Analytics is part ...
