AnsweredAssumed Answered

Column Chart : Multiple X-Axis Values?

Question asked by Dave_3.0 Champion on Jan 22, 2016
Latest reply on Jan 26, 2016 by am1

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).

 

 

Outcomes