Forum Discussion
Add a data field that does NOT impact visual
I think that with measures, you only get the ability to choose the actual measure at the top-level and not any specific values, as this is how selectors work. I would anticipate that you would get the same functionality as the core maxtrix visual's properties, e.g. if I have two measures in my matrix data view I get the following in the properties pane:
I can't do anything with the measure values here, just configure properties at a measure level.
With the categorical mapping you can get distinct group or series values, but I don't think that the matrix mapping has similar levels of aggregation when it comes to selectors.
I'm of the opinion that you're going to have to ask the custom visuals team for the functionality you're looking for, as this still would involve adding a secondary dataset to the visual, which is currently not possible.
Hi dm-p ,
First of all, I want to thank you many times over for your efforts here. You always deliver well written and researched answers and it is extremely helpful in so many ways.
Second, is it truly not possible to get any form of data in a "secondary query"? E.g. the field picker formatting setting? I found it yesterday while researching this issue and tried setting one up, as you can see here.
My hope was that this would allow for some sort of querying of data that would not necessarily impact the visual. As these would be captured in the option.dataview.metadata.objects rather than option.dataview.matrix. I am used to the formatting settings not impacting visuals in any way unless I program it to. I thought perhaps this would be similar - but I may be mistaken?
As always, thank you for your diligent help.
- Jonas
Hi JSJB, and glad you've found my help useful! I really appreciate it.
The field dropdown is used to assign properties to a measure or column based on selection ID, much like for the core visuals when properties will swap out based on what you choose in this dropdown. The changes you make will place corresponding objects in the data view based on the selection ID of the entry. Selection IDs must pertain to existing measures or columns in the data view, so unfortunately it doesn't provide any additional functionality for querying the data mode (just pushing things to the metadata).
To the best of my knowledge if you'r eusing the matrix data view mapping you would need to use selection IDs at the cell level, so you'd likely get a property entry for each (and in which case, it's probably better to use a dedicated data role and measure, as it would resolve to the same grain. Also, it looks like conditional formatting properties aren't supported for the matrix data view, which is a great shame (but probably for the same reasons).
Regards,
Daniel