Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Data reduction algorithm

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 ...
Need Help
Need Info
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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