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 ...
  • harikm007's avatar
    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