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" END
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..