Forum Discussion
Using measures data inside "Formattng settings"
dm-p,
Thank you so much for detailed answer 😊
To be honest, I'm not sure If I have chosen the correct way for achieving separate lists.
Could you tell me if exists any way to avoid duplication around data mapping from different tables.
For now, I have “1 task” and “5 events”,
In the result, we see task “5 times" instead “1 time”.
I would like to have 2 separate lists, if it is possible:
"tasks" - 1 item
"events" - 5 items
I guess reason is in dataViewMappings.
Capabilities.json:
{
"privileges": [],
"dataRoles": [
{
"displayName": "Tasks and Hierarchy",
"name": "Tasks",
"kind": "Grouping"
},
{
"displayName": "Start Date",
"name": "StartDate",
"kind": "Measure"
},
{
"displayName": "Dynamic event",
"name": "DynamicEvent",
"kind": "Measure"
},
{
"displayName": "Dynamic event label",
"name": "DynamicEventLabel",
"kind": "GroupingOrMeasure"
}
],
"dataViewMappings": [
{
"matrix": {
"rows": {
"for": {
"in": "Tasks"
},
"dataReductionAlgorithm": {
"top": {
"count": 30000
}
}
},
"values": {
"select": [
{
"for": {
"in": "StartDate"
}
},
{
"for": {
"in": "DynamicEvent"
}
},
{
"for": {
"in": "DynamicEventLabel"
}
}
]
}
}
}
],
"advancedEditModeSupport": 2
}
Thank you in advance 🤗
I think with a matrix data view, you're confined to the row/column/cell combination for each data point and probably can't do much to change or manipulate the grain.
I know that Charticulator had some data modelling instructions for ensuring a degree of compatibility to the web app (which had a main dataset and one for node relationships), but this uses the categorical mapping, so I'm not sure if you could get simialr results, but could be worth a look.
- Roman-Korovets3 years agoFrequent Visitor
Thank you so much,
I will take a look 🙂