Maybe I need more coffee, but I can't work this out...
I have say 10000 documents in a time period, one of the fields in a document is 'type' and there are, say 50 different values for 'type' in this document set.
I want to display a single metric visualization that is the average count across all the types, i.e. 200 in this example.
I can't see how to do this without a data table with rows split by 'type', displaying the average at the bottom, but this only works for the first N unique values of 'type', and I don't want to see all the unique values of 'type'
Bonus points for an example that uses Visual Builder.