1 2 Previous Next 16 Replies Latest reply on Jan 2, 2014 6:48 AM by sayak.m

    Create separate measures from a single measure for each dimension

    sayak.m

      I am a new Tableau user and I am stuck at this issue. I have created a sample data set below.

      What I am looking is to create a trend chart that has 2 lines (on top of each other)- one for Region and the other for State each representing the average Sales by by month. If possible I would like to filter for region and state.

       

      Basically I want to see is bench mark my state's performance to its region. I may have zipcodes we well with the city data, which I haven't used now.

       

      Any guidance will be greatly appreciated. Again I am new tableau user. Thanks in advance for taking the time.

       

      MonthRegionStateCitySales
      1NortheastMABoston70
      1NortheastMANorwood33
      1NortheastMAFramingham66
      2NortheastMABoston66
      2NortheastMANorwood48
      2NortheastMAFramingham27
      3NortheastMABoston82
      3NortheastMANorwood26
      3NortheastMAFramingham75
      1WestCAAnderson75
      1WestCABurbank47
      1WestCAFairfax49
      2WestCAAnderson71
      2WestCABurbank77
      2WestCAFairfax69
      3WestCAAnderson28
      3WestCABurbank78
      3WestCAFairfax35
        1 2 Previous Next