Forum Discussion

ajque's avatar
ajque
Cloud Apps
06-28-2023
Solved

Hyperlink KPI Widget

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. 

Blox
dashboards & reporting
Information Technology Analytics
Marketing Analytics
  • irismaessen's avatar
    irismaessen
    06-30-2023

    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.

     

3 Replies

Replies have been turned off for this discussion
  • irismaessen's avatar
    irismaessen
    Data Pipeline
    06-29-2023

    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.

    • ajque's avatar
      ajque
      Cloud Apps
      06-29-2023

      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's avatar
        irismaessen
        Data Pipeline
        06-30-2023

        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.