I have 2 types of documents:
Doc ID 1 documents:
Doc ID 2 documents:
I want to group these by user_id, and display the average of the metric in different columns based on the doc_id.
So the table would look like this:
User | doc_id:1 | doc_id:2 bob | 50 | 30 john | 60 | 40
But I cannot figure out how to setup this. I am trying to do 2 queries, first one is where doc_id=1 and the second one is where doc_id=2. Grouping these by term user_id, and tried to configure the table to different display formats but somehow I am not getting there.
Any help would be appreciated.