2 Replies Latest reply on Mar 10, 2016 1:58 PM by Gerry Zakharian

    Aggregate Calculation Error and Filter Display

    Gerry Zakharian

      Hello Everyone,

       

      Backstory: I'm working on a dashboard that involves metrics from YouTube. For a little more backstory, see here... https://community.tableau.com/message/465044#465044

       

      My Issue: I have two things that I'm having a hard time with.

      • Dynamic filter - I have a filter that I'm applying from my second data source (series). I would like this filter to only display relevant values like I did with my Channel Name filter. I've tried changing it in every way, but can't seem to figure out how to make that work.
      • Aggregate Calculation - I would like to create a calculated field to give me the average views per episode. When I calculate Views/Number of Episodes I get this error... "Cannot mix aggregate and non-aggregate arguments with this function.". I searched and couldn't get very far.

       

      I've attached a small sample file.

       

      Thank you in advance for any help/insight!