Custom visual: Issue with dataReductionAlgorithm in capabilities.json

Anonymous — Sun, 07 Mar 2021 18:34:37 GMT

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} } } } } ]

Re: Custom visual: Issue with dataReductionAlgorithm in capabilities.json

Anonymous — Sun, 07 Mar 2021 20:54:35 GMT

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} } } } } ]

topic Custom visual: Issue with dataReductionAlgorithm in capabilities.json in Developer

Custom visual: Issue with dataReductionAlgorithm in capabilities.json

Re: Custom visual: Issue with dataReductionAlgorithm in capabilities.json