Forum Discussion

zohebakber's avatar
zohebakber
Cloud Apps
01-02-2023
Solved

Dynamic Text Widget

Hi,

I am looking for a solution where I can add a text with dynamic numbers according to the values/formula given.
For Example: Best country in terms of Profit is "India".
In the above statement Country(India) is dynamic. As an, the country might change for different dates etc.

Any solution regarding this would be of great help.

Thanks

Sijo1995 

dashboards & reporting
  • harikm007's avatar
    harikm007
    01-02-2023

    Hi zohebakber ,

    One solution is to create a blox widget.

    Steps:

    1. Create a Blox with below script

    {
    "style": "",
    "script": "",
    "title": "",
    "showCarousel": true,
    "body": [
        {
            "type": "Container",
            "items": [
                {
                    "type": "TextBlock",
                    "text": "Best region in terms of Profit is <b>{panel:Region}</b>",
                    "style": {
                        "text-align": "center",
                        "font-size": "14px",
                        "margin": "100px"
                    }
                }
            ]
        }
    ],
    "actions": []
}

    2. Add 'Country' as item and 'Profit' as value/measure. Add widget filter on Profit to get TOP 1 country based on profit

     

    -Hari

     

     

2 Replies

Replies have been turned off for this discussion
  • harikm007's avatar
    harikm007
    Data Warehouse
    01-02-2023

    Hi zohebakber ,

    One solution is to create a blox widget.

    Steps:

    1. Create a Blox with below script

    {
    "style": "",
    "script": "",
    "title": "",
    "showCarousel": true,
    "body": [
        {
            "type": "Container",
            "items": [
                {
                    "type": "TextBlock",
                    "text": "Best region in terms of Profit is <b>{panel:Region}</b>",
                    "style": {
                        "text-align": "center",
                        "font-size": "14px",
                        "margin": "100px"
                    }
                }
            ]
        }
    ],
    "actions": []
}

    2. Add 'Country' as item and 'Profit' as value/measure. Add widget filter on Profit to get TOP 1 country based on profit

     

    -Hari