Drill To Buttons

hey liamcameron and gwolfe ,

Based on the screenshot provided, it appears that the goal is to identify the widgets that have the drill hierarchies feature, allowing end users to utilize this functionality.
Having an Indication of Drill can be set up Using the Script Below. 

Generally, the Drill Hierarchy feature offers two options:

1. Automatically including the hierarchy when adding dimensions.
2. Selecting the hierarchy at the time of adding dimensions.

See Related Screenshot

Script Overview

1. Check all the Panels for Each widget for Hierarchies/activeHierarchies element. 
   For Automatically including the hierarchy - the element exist only after selecting a hierarchy, otherwise the script will not indicate that the widget can be drilled. 
   Steps to Follow:
   - Add the dimension column 
   - save the widget
   - right click on hierarchy and click on drill 
   - Hierarchies/activeHierarchies element will be available and the Icon will appear. 
   

   For Selected Hierarchies
   - Add the Dimension Column 
   - Select the Hierarchy 
   - Hierarchy element will be available 
   
   

     
   

2. Include an icon indicating drill functionality in the widget title:

   • The icon is placed before the widget title without overwriting it.
   • The icon can be replaced in the drill_icon variable
   • The icon position can be adjusted.

3. Add a guide for the end user to the widget description:

   • The description is initially predefined but can be customized in the additional_text variable
   • Append the information to the existing widget description.

Implementation

1. Open the Dashboard Options.
2. Navigate to Edit Script.
3. Paste the script provided below.
4. Refresh the dashboard to apply the changes.

Dashboard Script

/* update the following variable */ 

var drill_icon = '🔽 '; /* replace with the icon */ 
var additional_text = ' Right Click to Drill Hierarchies'; /* replace with the widget description */ 


dashboard.on("refreshend", function(se, ev) {
    // Get all widgets from the dashboard
    var widgets = se.widgets.$$widgets;
    // Iterate through each widget
    widgets.forEach(function(widget) {
        // Get the widget's metadata panels and other necessary properties
        var widgets_metadata = widget.metadata.panels;
        var widget_oid = widget.oid;
 
        // Iterate through each panel in the widget's metadata
        widgets_metadata.forEach(function(panel) {
            // Iterate through each item in the panel
            panel.items.forEach(function(item) {
 
// Check if the item has hierarchies
                if (item.hierarchies || item.activeHierarchy) {
                    $(`widget[widgetid="${widget_oid}"] widget-header .app-icon--general-info-circle`).css('color', 'red');
                    $(`widget[widgetid="${widget_oid}"] widget-header .app-icon--general-info-circle`).closest('.widget-toolbar-btn').css('opacity', '1');
 
                    // Adding widget description and Icon to the title
                    if (!widget.title.includes(drill_icon)) {
                        widget.title = drill_icon + widget.title;
                    }
                    if (!widget.desc.includes(additional_text)) {
                        widget.desc += additional_text;
                    }
                } 
            });
        });
    });
});

Best Regards