Clarity

  • 1.  Stacked column portlet grouped by Department and Work Status

    Posted Nov 01, 2016 06:36 PM
      |   view attached

    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

    Attachment(s)

    xlsx
    portletMockup.xlsx   16 KB 1 version


  • 2.  Re: Stacked column portlet grouped by Department and Work Status

    Posted Nov 01, 2016 08:44 PM

    Example below of a stacked graph in Clarity with the option to select items by using the filtering.

    Stacked Graph Example



  • 3.  Re: Stacked column portlet grouped by Department and Work Status

    Posted Nov 02, 2016 09:07 AM

    Thanks Roland. Can you explain how you built this?



  • 4.  Re: Stacked column portlet grouped by Department and Work Status

    Posted Nov 02, 2016 11:00 AM

    If I understand right your query is returning "Work Status" as a 'column'?

     

    I think you need to restructure the query ; it needs to deliver metrics (columns) that are the COUNT of things in that 'Work Status'.SO you would have 4 separate metrics (columns of data) for counts of  Active, Complete, OnHold, Requested

    The dimension of the query would just be your 'departments'.



  • 5.  Re: Stacked column portlet grouped by Department and Work Status

    Posted Nov 02, 2016 01:39 PM

    I don't have a query; I was trying to accomplish it using the out of the box configuration options. My question was if this were actually possible, or if I'd need to code it. I guess I do.



  • 6.  Re: Stacked column portlet grouped by Department and Work Status

    Posted Nov 03, 2016 04:15 AM

    Ahh yes - sorry for jumping to a conclusion  - a NSQL query based portlet can deliver this!



  • 7.  Re: Stacked column portlet grouped by Department and Work Status

    Posted Nov 03, 2016 09:03 AM

    Ok, thanks! I'll get to work.