1 Reply Latest reply on Jul 18, 2013 7:49 AM by Mark Holtz

    How to layer a filtered graph onto an unfiltered graph in the same sheet?

    Phil Pierce

      I have a ton of data and I need to display the sum of that data (SUM(LiveCall)) in a line graph while filtering by a Dimension and showing an individual employees' SUM (LiveCall) graph without that filter affecting my original graph. Every time I filter by the dimension (employee name) it affects both graphs. How can I combine these two?

        • 1. Re: How to layer a filtered graph onto an unfiltered graph in the same sheet?
          Mark Holtz

          Phil,

          It would be a lot easier to assist you if you could provide a packaged workbook with your issue. I try to reference Shawn's handy guide as much as possible:

          Why Your Question Didn't Get Answered

           

          From the sound of your description, you might be able to create a conditional measure as a calculated field by setting up an IF statement. If you are always selecting a single employee, you could potentially use a parameter to dictate what goes into the calculated field, and then you can have an unfiltered version of your LiveCall measure in the same view.

           

          Another option might be to utilize a duplicate data source. A filter will only apply to one data source, so you could pull the LiveCall measure from the filtered source in conjunction with the LiveCall measure from the unfiltered copy.

           

          Hopefully that's helpful. If you need further assistance, please provide a packaged workbook.

          Cheers