Hey guys,
I'm writing a custom matrix visual . The dataview has a matrix , when I get measures data(Values) , I need to know what type of aggregation measure is (sum, count , average , min ,max ).
How can I get measure aggregation type programmatically?
Here is my capabilities.json
{
"dataRoles": [
{
"displayName": "Rows",
"name": "rows",
"kind": "Grouping"
},
{
"displayName": "Columns",
"name": "columns",
"kind": "Grouping"
},
{
"displayName": "Filters",
"name": "filters",
"kind": "Grouping"
},
{
"displayName": "Values",
"name": "measure",
"kind": "Measure"
}
],
"dataViewMappings": [
{
"conditions": [
{
"rows": {
"max": 0
},
"columns": {
"max": 0
},
"measure": {
"min": 1
}
},
{
"rows": {
"min": 1
},
"columns": {
"min": 0
},
"measure": {
"min": 0
}
},
{
"rows": {
"min": 0
},
"columns": {
"min": 1
},
"measure": {
"min": 0
}
}
],
"matrix": {
"rows": {
"select": [
{
"for": {
"in": "rows"
}
},
{
"for": {
"in": "filters"
}
}
],
"dataReductionAlgorithm": {
"top": {
"count": 30000
}
}
},
"columns": {
"for": {
"in": "columns"
},
"dataReductionAlgorithm": {
"top": {
"count": 10000
}
}
},
"values": {
"select": [
{
"bind": {
"to": "measure"
}
}
]
}
}
}
],
"objects": {
"total": {
"displayName": "Show Total",
"properties": {
"columnTotal": {
"displayName": "Column",
"type": {
"bool": true
}
},
"rowTotal": {
"displayName": "Row",
"type": {
"bool": true
}
},
"columnGrandTotal": {
"displayName": "Grand Column",
"type": {
"bool": true
}
},
"rowGrandTotal": {
"displayName": "Grand Row",
"type": {
"bool": true
}
}
}
}
}
}
