Tableau Tutorial - Adding a Total Line to a Line Chart

Поделиться
HTML-код
  • Опубликовано: 14 дек 2024

Комментарии • 4

  • @EuniceChin-sc3sx
    @EuniceChin-sc3sx Месяц назад

    Hi. Very useful! How can we add a color legend for this new total line?

    • @TableauWeston
      @TableauWeston  Месяц назад

      I'm not sure I fully understand the question, so I'll give two answers. If you want to change the color, click on the color card to pick the color you want. Somewhere there is an option to show color, or show legend. It might be under the analysis menu, or might be right-clicking the measure. Look around and let me know if you can't find it.

    • @jackbivona2474
      @jackbivona2474 17 дней назад

      @@TableauWeston On the right of the chart there is a color legend indicating which color corresponds to which category. With this method, there is no "total" color legend. How do we add this?

    • @TableauWeston
      @TableauWeston  17 дней назад

      @@jackbivona2474 I don't know of an "easy" way to create a Legend for the TOTAL line. Here is what you can do. 1) After you create the dual axis chart, open the SUM(Dollars)(2) card. You will see [Location] on the color card. Drag [Measure Names] on to the color card. 2) This should give you another color legend. You can unhide the legend title. There will still be a gap between the two legends but that is as close as I know how to get them. 3) To change the name in the color box itself, you can edit aliases of the [Measure Names] and look for SUM(Dollars)(2). Another option is to create a field equal to SUM(Dollars) and call it total. Hope that helps.