Custom visual: Issue with dataReductionAlgorithm in capabilities.json

[Triplee74]

Hi,

I am having issues with my dataReductionAlgorithm. I have attached my capabilities.json code below.

I am working on a custom visual with 3 fields, one category and two measures. My issue is that the dataReductionAlgorithm only fires if I add ALL three field into the visual, then it limits the data table to 1 row. Until I add all 3 fields, the data table includes ALL data.

Any ideas?

"dataRoles": [
        {
            "displayName": "KPI Name",
            "name": "category",
            "kind": "Grouping"
        },
        {
            "displayName": "KPI Value",
            "name": "kpimeasure",
            "kind": "Measure"
        },
        {
            "displayName": "Target Value",
            "name": "targetmeasure",
            "kind": "Measure"
        }
    ],

"dataViewMappings": [ {
            "conditions": [
                {
                    "category": { "max": 1},
                    "kpimeasure": { "max": 1},
                    "targetmeasure": { "max": 1}
                }
            ],
            "categorical": {
                "categories": { 
                    "for": { "in": "category" },
                    "dataReductionAlgorithm": { "top": {"count": 1} } 
                },
                "values": {
                    "select": [
                        { "bind": { "to": "kpimeasure" } },
                        { "bind": { "to": "targetmeasure" } }
                    ],
                    "dataReductionAlgorithm": { "top": {"count": 1} } 
                }
            }
        }
    ]

[Triplee74 · Accepted solution]

After some testing I suddenly got it to work, to be honest I don't know why. 

    "dataViewMappings": [ {
            "conditions": [
                {
                    "category": { "max": 1},
                    "kpimeasure": { "max": 1},
                    "targetmeasure": { "max": 1}
                }
            ],
            "categorical": {
                "categories": { 
                    "for": { "in": "category" },
                    "dataReductionAlgorithm": { "top": {"count": 1} } 
                },
                "values": {
                    "select": [
                        { "bind": { "to": "kpimeasure" } },
                        { "bind": { "to": "targetmeasure" } }
                    ],
                    "dataReductionAlgorithm": { "top": {"count": 1} }
                }
            }
        }
    ]