Forum Discussion
Getting aggregated value across dimension members
Hello everyone !
I would like to know if there is a way to obtain the aggregation's calculated value for selected dimensions and measure. By investigating the dataView, have seen that there were some data with null dimensions (along with dimension time and value) :
would they be the aggregated value for each time-dimension member ?
P.S.: The data also includes the values for each third dimension - instead of null here -
2 Replies
Please provide sample data in usable format and show the expected outcome.
Sorry, the post is not clear enough. Let's say we have a data model with a measure "score":
+-------+
| score |
+-------+
| 150 |
+-------+
Let's say there's also a dimension "signature" that we add to the custom visual afterwards. The dataview is now:
+-----------+-------+
| signature | score |
+-----------+-------+
| math | 50 |
+-----------+-------+
| biology | 50 |
+-----------+-------+
| english | 50 |
+-----------+-------+
The question is: assuming we have score by signature in the dataview already, is there a way to get the aggregate value (150) via the custom visuals API? we think not, but we'd like to get official confirmation.
Hopefully this is clear enough. Let me know
