cancel
Showing results for 
Search instead for 
Did you mean: 

Hyperlink KPI Widget

ajque
8 - Cloud Apps
8 - Cloud Apps

Hello Experts! 
Client requested to have the KPI widgets (Indicator) contain hyperlinks that would direct them to another dashboard or site link once clicked. 
Is that possible? Hoping someone can help me with this ask. 
Any tips will do!
Thank you in advance. 

1 ACCEPTED SOLUTION

irismaessen
11 - Data Pipeline
11 - Data Pipeline

Instead of JTD in combination with BloX, you could also try the OpenURL action with a URL to the dashboard you want to open. You can even set filters on the dashboard to be opened with the filter JAQL and pass values from the widget panes in the BloX widget into the filterJAQL/Url. 

This might be a sample blox script (minus the styling block).  I'm not opening a dashboard here but it does demonstrate the principle of passing a value into the url:

{
    "style": "",
    "script": "",
    "title": "",
    "showCarousel": true,
    "body": [
        {
            "spacing": "medium",
            "type": "Container",
            "items": [
                {
                    "spacing": "small",
                    "type": "TextBlock",
                    "text": "{panel:GroupBy} ",
                    "color": "default",
                    "horizontalAlignment": "center"
                },
                {
                    "type": "TextBlock",
                    "text": "{panel:Aggregation}",
                    "horizontalAlignment": "center",
                    "size": "extraLarge",
                    "style": {
                        "color": "#117899"
                    }
                },
                {
                    "spacing": "small",
                    "type": "TextBlock",
                    "text": "<span class='blox-sparkline' type='line' line-color='#117899' width='200' height='50' line-width='3' fill-color='#B2D4DF' point-color:'#117899'>{panel:Aggregation}</span>",
                    "horizontalAlignment": "center",
                    "size": "medium",
                    "weight": "bold",
                    "color": "grey"
                }
            ]
        }
    ],
    "actions": [
        {
            "type": "Action.OpenUrl",
            "title": "Open In Web",
            "url": "https://www.sisense.com/sisense-labs/?test={panel:GroupBy}"
        }
    ]
}

 

This has its own limitations but it could be worth experimenting.

 

View solution in original post

3 REPLIES 3

irismaessen
11 - Data Pipeline
11 - Data Pipeline

To open a dashboard when clicked, you can use the Jump to Dashboard plugin/functionality. For an indicator widget, this can be set to open a jump dashboard when the widget is clicked.

To open a dashboard *or* a link, depending, you may be able to use an action button in a BloX widget (which can be designed to do either). This will only work *easily* if your indicators use a numbers style though, not with gauges (I bow to the user who can create a gauge in BloX). Although you *can* add a sparkline to these indicators in Blox.

Thanks for responding!
We're hesitant to use the Jump to function as it's a little wonky. It's not as effective for our clients as they embed the original dashboard to an internal site (reports repository). 
Was hoping to look for a work around aside from Jump to. 
Anyway, appreciate your insights! 

 

irismaessen
11 - Data Pipeline
11 - Data Pipeline

Instead of JTD in combination with BloX, you could also try the OpenURL action with a URL to the dashboard you want to open. You can even set filters on the dashboard to be opened with the filter JAQL and pass values from the widget panes in the BloX widget into the filterJAQL/Url. 

This might be a sample blox script (minus the styling block).  I'm not opening a dashboard here but it does demonstrate the principle of passing a value into the url:

{
    "style": "",
    "script": "",
    "title": "",
    "showCarousel": true,
    "body": [
        {
            "spacing": "medium",
            "type": "Container",
            "items": [
                {
                    "spacing": "small",
                    "type": "TextBlock",
                    "text": "{panel:GroupBy} ",
                    "color": "default",
                    "horizontalAlignment": "center"
                },
                {
                    "type": "TextBlock",
                    "text": "{panel:Aggregation}",
                    "horizontalAlignment": "center",
                    "size": "extraLarge",
                    "style": {
                        "color": "#117899"
                    }
                },
                {
                    "spacing": "small",
                    "type": "TextBlock",
                    "text": "<span class='blox-sparkline' type='line' line-color='#117899' width='200' height='50' line-width='3' fill-color='#B2D4DF' point-color:'#117899'>{panel:Aggregation}</span>",
                    "horizontalAlignment": "center",
                    "size": "medium",
                    "weight": "bold",
                    "color": "grey"
                }
            ]
        }
    ],
    "actions": [
        {
            "type": "Action.OpenUrl",
            "title": "Open In Web",
            "url": "https://www.sisense.com/sisense-labs/?test={panel:GroupBy}"
        }
    ]
}

 

This has its own limitations but it could be worth experimenting.