1 Reply Latest reply on Dec 19, 2016 11:48 AM by Patrick A Van Der Hyde

    Dashboard setup based on Google Analytics data

    Dan Metelkin

      Hello, data experts!

       

      I'm setting up a quite simple dashboard where I need to filter Source and Medium numbers filtering by Goals. Basically, it should show me Source and Medium numbers for particular Goal when I click on the Goal, but it doesn't do that (

      I'm attaching the file (done in Tableau 10) and would much appreciate if someone can advise on how to do that.

        • 1. Re: Dashboard setup based on Google Analytics data
          Patrick A Van Der Hyde

          Hello Dan,

           

          Are you trying to get your source and medium numbers to only display the related goals# completions values for each source?  If so, the issue would be that you are trying to slice the measures in Source and medium by another measure - in this case the Goals Completions.  We need a Dimension instead to tie these together.  We can do the reverse though - by selecting one of the Dimenion values from Source or medium, we can filter the Goals chart to show the related values.  That piece is already working correctly in the viz though. It is possible to create a link from the Goals chart to the Source and medium to show the Sources that make up a selected sub group by adding Source and Medium to the marks card.  This will divide up the Goals chart bars however and then the selected Source or Medium chart is a filter for the related Dimension but not for the User measure that appears.

           

          I looked at the data and the goals are not exclusive either (some rows of data have values greater than 0 for multiple goals) so going from goals to filter medium or source would not work even if we pivoted the data a bit to try and create a dimension.

           

          Patrick