Hi there -
why not create some basic sql view and use a data connection to make that view available in console for queries and stuff?
You can do lot's of magic and some cool KPI-like dashboards.
Thanks for the suggestion, that will work a treat. It would be useful to have the view built into the product though as many customers do not have access to sql expertise. I will add an enhancement request for it.
Let me know if you need some examples - didn't really want to post them