cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Dynamic Text Widget

zohebakber
9 - Travel Pro
9 - Travel Pro

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 

1 ACCEPTED SOLUTION

harikm007
13 - Data Warehouse
13 - Data Warehouse

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

harikm007_0-1672663306418.png

 

-Hari

 

 

View solution in original post

2 REPLIES 2

harikm007
13 - Data Warehouse
13 - Data Warehouse

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

harikm007_0-1672663306418.png

 

-Hari

 

 

zohebakber
9 - Travel Pro
9 - Travel Pro

Awesome Hari!
Thanks..
You have been of grt help...