How exactly could I do that?
Currently I have this:
{
"dataRoles": [
{
"displayName": "Category 1",
"name": "category",
"kind": "Grouping"
},
{
"displayName": "Category 1 & 2",
"name": "category2",
"kind": "Grouping"
},
{
"displayName": "Measure Data",
"name": "measure",
"kind": "Measure"
}
],
"dataViewMappings": [
{
"conditions" : [
{
"category": { "max": 1 },
"category2": { "max": 2 }
}
],
"table": {
"rows": {
"select": [
{ "bind": { "to": "measure" } },
{ "for": { "in": "category" } },
{ "for": { "in": "category2" } }
]
}
}
}
]
}Basically, I want the measures filtered by 'category' AND (completely separately) filtered by everything in 'category2'. That's not what this mapping does - how can I change it to get what I need?
For example: if Category and Subcategory are two columns in my data, I would be to put Category in the 'category' field and Category AND Subcategory in the 'category2' field. The filtering by 'category' would give the aggregate values per Category and filtering by 'category2' would give the values one level further down in the hierarchy, for each combination of Category and Subcategory.
