AnsweredAssumed Answered

Stacked column portlet grouped by Department and Work Status

Question asked by ClareLeonard76040337 on Nov 1, 2016
Latest reply on Nov 3, 2016 by ClareLeonard76040337

Hi,
One of my customers would like to see projects grouped by Department, then Work Status, in a stacked column chart. Attached is a mockup I did in Excel. I'm having trouble because I am not able to select Work Status as a metric, since it is a string field. In the portlet config, I can only select one Group By. Does anyone know if there is a way to accomplish this within configuration, or would I have to write a custom query?

Thanks,
Clare

Attachments

Outcomes