Forum Discussion

ysapiyev's avatar
ysapiyev
Responsive Resident
8 years ago
Solved

How data reduction algorithm works?

hi everyone,

 

I have a problem with data reduction algorithm. As I understood from the tutorials, data algorithm works to limit data selection. 

Here is my code in capabilities

"values": {
				"group": {
                "by": "date",
                    "select": [		
						
						{
                            "bind": {
                                "to": "value1"
                            }
                        },
						{
                            "bind": {
                                "to": "value1_unit"
                            }
                        },
                        {
                            "bind": {
                                "to": "value2"
                            }
                        },{
                            "bind": {
                                "to": "value2_unit"
                            }
                        },
                        {
                            "bind": {
                                "to": "value3"
                            }
                        },{
                            "bind": {
                                "to": "value3_unit"
                            }
                        },
                        {
                            "bind": {
                                "to": "value4"
                            }
                        },{
                            "bind": {
                                "to": "value4_unit"
                            }
                        }

                    ]
					,
					"dataReductionAlgorithm": {
						"bottom": {
						 "count": 1
					 }
					}
					}
                }

By logic, it should group my values by date and select latest, since I'm choosing bottom 1. However, I get all of the data. Where is the problem? Or is there more detailed manual for algorithm.

7 Replies

  • v-viig's avatar
    v-viig
    Community Champion

    You have to specify dataReduction for categories as well to limit amount of data rows.

     

    Ignat Vilesov,

    Software Engineer

     

    Microsoft Power BI Custom Visuals

    [email protected]

    • ysapiyev's avatar
      ysapiyev
      Responsive Resident

      v-viig,

       

      I used same data reduction function for categories, with bottom and count equal to 1. However, I still get full amount of data.

      • v-viig's avatar
        v-viig
        Community Champion

        Please share the whole capabilities.json

         

        Ignat Vilesov,

        Software Engineer

         

        Microsoft Power BI Custom Visuals

        [email protected]