3 Replies Latest reply on Sep 6, 2016 12:02 PM by joe.rodriguez.3

    Could use some help.

    Edward Peugh

      Hey All,


      I am new to the group, and also generally new to Tableau.


      Having trouble with getting my mind around a specific idea.  I have an average cost of products by month, for a series of transactions.  This average cost varies from month to month.  The average can be impacted by a couple of different variables such as Product Type Purchased, Channel of Purchase, Geographic location of this purchase, etc.


      Having a hard time creating a view that helps understand the impact of each of these variables over time.  Has anyone seen a dashboard approach that has done this effectively?  (I am asking this question more out of a conceptual position, then a technical one...)





        • 1. Re: Could use some help.

          Hey Ed,


          I'm doing some purchase price variance exercises as we speak. To be clear, you want to understand cost variation month over month, and break it down to understand how much of that variation was driven by product mix, channel and geography? My first guess would be to have your average cost on a line graph at the top, with more detailed breakdowns underneath (Maybe lines graphs, or simple tables) for top products, channels and locations. With pricing constant, you should be able to explain changes from the average cost above by looking at the stuff below.  If the 80/20 rules applies, your top 5 or so products, channels and locations will do most of the driving here. You also want to probably capture any changes in price...more so for YOY comparisons.



          • 2. Re: Could use some help.
            Edward Peugh

            Joe, You have it basically right...  so one of the major dynamics that has been tough to capture is that price paid for a service is not constant.  Meaning even in a month where mix by Product, Channel, and geography are constant, we can still have a price variance...  ed

            • 3. Re: Could use some help.

              I'm thinking breaking down your service pricing might be the first step to figure out if possible. It'll be tough to pin it down on something if this pricing patterns are too vague. Is there anything in the data model that can you give more detail behind service pricing? Hours (Any unit of measure), service type, customer type, rep, etc.