Forum Discussion

ysapiyev's avatar
ysapiyev
Icon for Responsive Resident rankResponsive 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
    Icon for Community Champion rankCommunity 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
      Icon for Responsive Resident rankResponsive 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
        Icon for Community Champion rankCommunity Champion

        Please share the whole capabilities.json

         

        Ignat Vilesov,

        Software Engineer

         

        Microsoft Power BI Custom Visuals

        [email protected]