1 Reply Latest reply on Sep 11, 2018 9:11 AM by Deepak Rai

    Change the item names in the legend - dual axis

    Charles Sasso



      I have two worksheets, one with one mark representing both current and historical data. The legend on this worksheet is perfect. I was able to change the item names without a problem by using a calculated field for the mark,

      // CI Current vs Historical
      If [Insert Date] = TODAY() Then "Today"
      Else "Historical"


      Now I have another worksheet with the same dimension as above BUT added a second dimension and created a DUAL-AXIS line graph.

      The legend now looks terrible with all the calculations in it. See screenshot.


      Maybe I need to create a new calculated field(s) that incorporates the one above and adds the new dimension?


      I really wish Tableau would just let me edit the item name like it does the title..