Can we get statistics from matrix based on the usage of metadata fields?
We have a set of pages that have specific metadata fields. Each fields has multiple selections. There are new pages being added to this set all the time. We want to be able to know how many pages there are in each set of multiple fields. Eg if the fields are colours, a single page could be red, blue, yellow.
Then if the other fields are flavours and days. The same page could have chocolate, vanilla; and Monday, Tuesday.
Can I get Matrix to count/graph/indicate in some way the pages that have eg blue, chocolate and Monday combinations irrespective of their other entries in their field?
An asset list puts all the pages with red, blue and yellow together, then those with red and blue separately, and blue as separate again. We want all these included as blue pages.
Thanks,
Catherine
I actually can't think of any simple way to do this. You may have to have something developed for you.
I'd say the easiest way would be to try and do this with DB Data Source (plus graph if you want to graph the results) and a customised DB query. But as Avi said, you'll need someone to at least develop this query for you.
I am wondering whether this topic might be able to help you:
Tag Clouds
I guess it depends on how complicated you can make the searches in the search list asset (which I haven't used yet). If that part works, then you can use JavaScript to interpret the data (with the canvass tag to draw graphs if you want) in the same way that the script Raena found turns the list into a tag cloud.