Hoping someone can help me out here. I have data stored in a less than ideal format but don't have a lot of options on changing that. The data basically has 3 parts that I need to extract:
Username and ID are in one document.
ID and MS are in a second document.
I need to get a chart that allows me to sort by MS, but shows the ID and Username all in one view.
I've been trying pie charts and data graphs and haven't been able to get anything to work. I can get all of the data in one view with an aggs query, but I'm not sure how I can graph on the keys that are returned from that search...
Can anyone point me in the right direction?
edit: One thing I was trying but wasn't able to get to work: I can get the x axis to display the ID, and the y axis to display and sort by largest the MS. One thing that I tried was seeing if there was a way with painless scripts or otherwise to 'rewrite' the ID to the username. Not sure if that can be done.