Forum Discussion

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago

Re: Pie Chart Total

Please try the Stacked Bar again and set the Series to be Phases.  The Y axis will just be # of Projects. The height of the Bar will be the total, alight you will need to estimate how high it looks against the Y 

An alternative would be to use the same report but obviously that's not very visual.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

9 Replies

Sort By
  • AnnettaColeman's avatar
    AnnettaColeman
    Qrew Cadet
    4 years ago

    Hi Mark - 

    In order for a stacked bar to 'stack' by phase if for Phase to be in the Y-axis.    Setting the series to Phase has same result as previously reported in anchoring the Phase to the X-axis which creates a standard bar chart with the same problem as the pie chart is that the total (number of projects of all phases) is not represented anywhere on the chart.

    I remain curious related to:

    1. What one would do with the report summary formula built in the report that counts distinct values?  I have created this but cannot figure out how to place the total anywhere on the chart.   
    2. How to create and trigger a 'companion gauge chart' you mentioned earlier in this thread?
    3. Maybe I didn't have enough coffee last night (or this AM), but it seems like I am missing a key fundamental aspect of pie (or stacked bar) charts to make them act like a standard industry pie or stacked bar chart that includes a simple total of the values in all slices of pie or all bars on chart. 



    ------------------------------
    Annetta Coleman
    ------------------------------

    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      4 years ago
      Can you try this and tell me the results. 

      1. Create a formula text field called [ALL].   The formula will be "ALL".
      2. Make a stacked Bar Chart with ...
       - X axis is [ALL]
       - Y axis is # of Projects
       - Series is Phase.

      As for your question 1, I don't see how that would help you to have the slices of the pie be count distinct values.   That won't help and you would lose the count of # of Projects.  I understand it, you want to be able to Visualize  the number of Projects by Phase and how are your users to use the dynamic filters to adjust which projects are included. 

      For the companion gauge chart comment that I made well that would give you a total there is not a way to have the dynamic filters on one report magically automatically adjust the dynamic filters on another report. When I answered that question I did not realize that your users wanted to adjust the dynamic filters, I thought it was just a static pie chart say on the dashboard.

      Give that Stacked Bar chart one more chance and let's see where we end up.  :)



       
      ​​

      ------------------------------
      Mark Shnier (YQC)
      mark.shnier@gmail.com
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        4 years ago
        When you put a stack bar chart on new dashboards they behave a bit differently than they do on regular reports or on regular home pages. The project counts for each of the stack bars would be embedded in the stack so they are easier to read.  And when you hover over the stack it will give you counts of all your individual Phases. Granted it still does not do the total that you are looking for but the Y axis gives that total visually. 

        Anyways I just wanted to point out that if the Stacked Bar Chart chart starts to get close to what you need and you throw it on a new dashboard, it behaves a bit differently and perhaps better for your use case.

        ------------------------------
        Mark Shnier (YQC)
        mark.shnier@gmail.com
        ------------------------------