Data reduction algorithm

[Anonymous]

Hi,

im working on custom visual that returns this error: "too many 'Task No' values" Not displaying all data. Filter the data or choose another field."

I tried to fix this according the data reduction algorithm: https://github.com/mvgaliev/PowerBI-visuals/blob/942d72065ec6703878249d32cb8df41a00827750/Capabiliti...

The error is due to "tasks".

so i tried this: (on capabilities.json)

    "categorical": {
                "categories": {
                    "select": [
                         {
                            "for": {
                                "in": "Task"
                            } , "dataReductionAlgorithm": {
                                "top": {
                                    "count": 30000
                                }
                            }
                        }, 
                        {
                            "for": {
                                "in": "Parent"
                            }
                        },
                    
                        {
                            "for": {
                                "in": "StartDate"
                            }
                        },
                        {
                            "for": {
                                "in": "Resource"
                            }
                        }
                    ]
                },
                "values": {
                    "group": {
                        "by": "Legend",
                        "select": [
                            {
                                "for": {
                                    "in": "EndDate"
                                }
                            },
                            {
                                "for": {
                                    "in": "Duration"
                                }
                            }
                        ]
                    }
                }
            }

But it seems to have no affect. I also tried to set property to "window" or "bottom" and reduce count.

[Anonymous]

solved:  

In my case it was necessary to place it after select in "categories" and "values"

  "categorical": {
                "categories": {
                    "select": [
                        {
                            "for": {
                                "in": "Task"
                            }
                        }, 
                        {
                            "for": {
                                "in": "Parent"
                            }
                        },
                    
                        {
                            "for": {
                                "in": "StartDate"
                            }
                        },
                        {
                            "for": {
                                "in": "Resource"
                            }
                        },
                        {
                            "for": {
                                "in": "ParentResource"
                            }
                        },
                        {
                            "for": {
                                "in": "ExtraInformation"
                            }
                        },
                        {
                            "for": {
                                "in": "Milestones"
                            }
                        }
                    ], "dataReductionAlgorithm": {
                        "top": {
                            "count": 30000
                        }
                    }  
                },
                "values": {
                    "group": {
                        "by": "Legend",
                        "select": [
                            {
                                "for": {
                                    "in": "EndDate"
                                }
                            },
                            {
                                "for": {
                                    "in": "Duration"
                                }
                            },
                            {
                                "for": {
                                    "in": "Completion"
                                }
                            }
                        ], "dataReductionAlgorithm": {
                        "top": {
                            "count": 30000
                           }
                        }  
                    }
                }
            }