top 10 stakeholder

[
  {
    "name": "wiews_area_filter",
    "sid": [ { "uid": "wiews_regions_mapping" } ],
    "result" : false,
    "parameters": {
      "m49": {
        "codes": [
          {
            "uid": "wiews_m49",
            "codes": [ "150" ]
          }
        ]
      }
    }
  },

  {
    "sid": [ { "uid": "indicator20" } ],
    "name" : "select",
    "parameters" : {
      "query" : "where m49_country in <<required_countries>>",
      "values" : {
        "genus":null,
        "iteration" : null,
        "domain" : null,
        "element" : null,
        "biologicalAccessionId" : null,
        "country" : null,
        "stakeholder" : null,
        "value" : null,
        "um" : null
      }
    }
  },

  {
    "name": "filter",
    "parameters": {
      "columns": [
        "stakeholder",
        "value",
        "um"
      ],
      "rows": {
        "iteration": {
          "codes": [
            {
              "uid": "wiews_iteration",
              "codes": [ "1" ]
            }
          ]
        },
        "!stakeholder" :{
          "codes": [
            {
              "uid": "wiews_stakeholder",
              "codes": [ "ZZZ" ]
            }
          ]
        }
      }
    }
  },

  {
    "name": "group",
    "parameters": {
      "by": [
        "stakeholder"
      ],
      "aggregations": [
        {
          "columns": [ "value" ],
          "rule": "SUM"
        },
        {
          "columns": [ "um" ],
          "rule": "max"
        }
      ]
    }
  },
  {
    "name": "order",
    "parameters": {
      "value": "DESC"
    }
  },
  {
    "name": "page",
    "parameters": {
      "perPage": 10,
      "page": 1
    }
  }




]