Data Viz Done Right

August 23, 2016

Tableau Tip Tuesday: How to Use Dynamic Grouping & Filtering for Competitor Analytics

2 comments

In this week’s tip, I show you how to compare your company to your competitors, but only for products that you both sell. In other words, you only want to compare products where in which you both compete.

2 comments :

  1. Hi Andie,

    Thank you for these amazing video as always. I had a query at timestamp 6:15 regarding calculated field
    If FIRST()=0 then WINDOW_MAX(RUNNING_SUM([Does Product Exist]))
    else RUNNING_SUM([Does Product Exist])
    END
    and then filter only 2.

    Instead can't we just use WINDOW_MAX(RUNNING_SUM([Does Product Exist]) Table across and filter 2. Please advise.

    Thanks,
    Jeremiah Lobo

    ReplyDelete
    Replies
    1. Sure, that sounds like it would work as well. Many ways to do things in Tableau. My brain works a bit too complicated at times and your way is much simpler. Thanks!!

      Delete