0

Creating multi-charts

I'm wondering how to combine charts into one plot. Currently, I have a time dimension on the x-axis, and I have two values I want to have on the y-axis (think "desktop minutes" and "mobile minutes" or something similar). When I try to create one single chart with two lines on it to represent each value, Pyramid 2018 automatically creates a trellis to separate these plots into two different plots. I can't figure out how to un-trellis the plots to have a single plot with two lines on it. Thanks in advance.

6 replies

null
    • Itamar_Birenzweig
    • 6 yrs ago
    • Reported - view

    Hi Ben,

    To achieve this, you will need to add one of the measure to the secondary Y axis.

    You can do this by dragging one of the measures to the Values icon and then to "Y2 Secondary Axis" and then to the chart type you would like use.

    See below screenshot:
      I hope that helps!

      • Nate_Meyer
      • 5 yrs ago
      • Reported - view

      Itamar Birenzweig I am hoping to use this functionality, but with the values from the Grand Totals.  Is there any way to get a Grand Totals "chip" to drag and drop in the chart?

      • "making the sophisticated simple"
      • AviPerez
      • 5 yrs ago
      • Reported - view

      Nate Meyer There is no totals chip. One way to solve it is to create a new measure that is the aggregate of the items you'er looks at using the Formulate tools and then plot that.  

      • Nate_Meyer
      • 5 yrs ago
      • Reported - view

      Avi Perez I've messed around with that and actually think I can get to the place I'm wanting visually, but it was a bit of a pain to get there.  Would it be possible to get another option on the Query ribbon > Analysis > Statistics for the Grand Totals?  I imagine it working similar to how the Average option in there works.

    • Ben_Croft
    • 6 yrs ago
    • Reported - view

    That quick walkthrough really helps! I didn't see that pop-out on the Values shelf for primary and secondary axes. Thank you!

    • Itamar_Birenzweig
    • 6 yrs ago
    • Reported - view

    Glad to help!

Login to reply

Content aside

  • Status Answered
  • 5 yrs agoLast active
  • 6Replies
  • 58Views
  • 4 Following