Filtering in a smaller number of items in the DASH Bar Chart widgets
Albook 120000625S Visits (5228)
Recently I've been ask to provide a suggestion about how to show a pre-configured number of items in the DASH Bar Chart Widget.
Customer wanted to show just the five mount points with the highest "Space Used Percent" for the Unix or Linux Disk attribute group.
Unfortunately, the Bar Chart widgets in DASH, as well as lot of other widgets, does not allow to specify the amount of rows needed from the dataprovider.
So I tried to look for an alternative solution, leveraging on the filters available for the Bar Chart widget.
You can identify a threshold value, something that help you getting the amount of rows returned by dataprovider low enough.
For example, if normally you have four or five mount points exceeding 20% of space used, you can then use this value in your filter.
in the Query Condition field.
Then, to get a sorted output we can select "Space Used Percent" in the field "Sort by Column" and "Descending" as Sort order.
Below you can find some images showing the proposed procedure.
Let's suppose we already have in the Required settings the following values:
In order to obtain what I suggested above, we have to expand the Optional Settings and provide the suggested information as follow:
Save the changes.
Hope it helps !!
Subscribe and follow us for all the latest information directly on your social feeds: