I really should know the answer to this, but it seems that I don't (and I have just spent an hour or two messing about with queries and portlets with no joy)....
What I want to build is a column chart portlet, with the x-axis being MONTHs and the y-axis being some project-related score.
But I also want to break the months down on the x-axis, into OBS levels - so I have a column for Jan2016 with individual columns within it for OBS1, OBS2,... etc, each with a score
(the OBS levels are dynamic of course and might change from month-to-month).
Can I do this? (or am I just imagining stuff that I can't build?)
I've tried building a various NSQL queries and basing column charts on them, but I get no options for adding a second dimension (OBS) to the (Month) x-axis - the studio documentation talks about a "Group By Column" in a chart-layout which sounds like what I want to do (Group by 'OBS') , but I don't see that option in the GUI anywhere (the options for chart portlets vary a lot depending on the type of chart and unfortunately the studio documentation doesn't help determine which option applies to which type that I can see).