How to add data resources to Data visualization type pie ?

[trungbeen27]

I have a GRAPQl and a Transform i need add transform to data sources in data visualization type pie like image
but it's not work.

[NagaChandaE]

Hi @trungbeen27 ,

Please Select the "Define data Manually" Check Box True and Map the Data .

Sample JSON : 

[
    {
        "data": [
            {
                "assignment_group": "(empty)",
                "value": "28"
            },
            {
                "assignment_group": "Service Desk",
                "value": "12"
            },
            {
                "assignment_group": "Hardware",
                "value": "9"
            },
            {
                "assignment_group": "Software",
                "value": "9"
            },
            {
                "assignment_group": "Network",
                "value": "6"
            },
            {
                "assignment_group": "Database",
                "value": "2"
            },
            {
                "assignment_group": "Openspace",
                "value": "1"
            }
        ],
        "metadata": {
            "eventData": {
                "table": "incident"
            },
            "dataSourceLabel": "Incident",
            "groupBy": [
                {
                    "series": [
                        {
                            "label": "Incident",
                            "id": "value",
                            "type": "value"
                        }
                    ],
                    "elements": [
                        {
                            "eventData": {
                                "query": "assignment_group="
                            },
                            "label": "(empty)",
                            "id": ""
                        },
                        {
                            "eventData": {
                                "query": "assignment_group=d625dccec0a8016700a222a0f7900d06"
                            },
                            "label": "Service Desk",
                            "id": "d625dccec0a8016700a222a0f7900d06"
                        },
                        {
                            "eventData": {
                                "query": "assignment_group=8a5055c9c61122780043563ef53438e3"
                            },
                            "label": "Hardware",
                            "id": "8a5055c9c61122780043563ef53438e3"
                        },
                        {
                            "eventData": {
                                "query": "assignment_group=8a4dde73c6112278017a6a4baf547aa7"
                            },
                            "label": "Software",
                            "id": "8a4dde73c6112278017a6a4baf547aa7"
                        },
                        {
                            "eventData": {
                                "query": "assignment_group=287ebd7da9fe198100f92cc8d1d2154e"
                            },
                            "label": "Network",
                            "id": "287ebd7da9fe198100f92cc8d1d2154e"
                        },
                        {
                            "eventData": {
                                "query": "assignment_group=287ee6fea9fe198100ada7950d0b1b73"
                            },
                            "label": "Database",
                            "id": "287ee6fea9fe198100ada7950d0b1b73"
                        },
                        {
                            "eventData": {
                                "query": "assignment_group=36c741fa731313005754660c4cf6a70d"
                            },
                            "label": "Openspace",
                            "id": "36c741fa731313005754660c4cf6a70d"
                        }
                    ],
                    "label": "Assignment group",
                    "id": "assignment_group",
                    "fieldType": "reference"
                }
            ],
            "format": {
                "unitFormat": "{0}"
            },
            "aggregateBy": 4,
            "metricId": "ZEdGaWJHVnBibU5wWkdWdWRERTJORFl5TXpRNE5UTXpNams9MTY0NjIzNDg1NTEwNg=="
        }
    }
]

[annb19]

Hi @trungbeen27 ,
It's not work because you tried to bind the transform output straight into the data source without turning on Define data manually. When that box isn’t checked, UI Builder doesn’t treat what you paste as manual JSON, so the chart can’t render it properly.

Hope this helps!