Excel Nested IF in Tableau

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

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

  • @onenumbertableau
    @onenumbertableau  Год назад

    Need help with your IF statements in Tableau? Schedule an hour with Eric here: www.eventbrite.com/e/tableau-office-hours-with-eric-parker-tickets-42691995909
    Ready to master Tableau? Check out our lineup of upcoming classes! www.eventbrite.com/o/onenumber-15678294163

  • @romanvasiura6705
    @romanvasiura6705 Год назад +1

    Thank you!

  • @uscgdavis
    @uscgdavis 3 года назад +2

    Excellent resource. Very informative!

  • @nafiulhaque5585
    @nafiulhaque5585 3 года назад

    Hello:
    IF 'Create Date' then "1" will be represented. If 'complete date' then " 0" between create to complete is considered is "pending".
    IF case [Created Date] THEN '1'
    ELSEIF [Completed Date] THEN '0'
    END
    I am getting error
    How can I form a calculated field in Tableau?

    • @onenumbertableau
      @onenumbertableau  3 года назад

      Hi Nafiul. How do these fields work? Is [Completed Date] NULL if a process is incomplete? Is [Created Date] NULL if a process is complete?

    • @nafiulhaque5585
      @nafiulhaque5585 3 года назад

      @@onenumbertableau Yes.

    • @onenumbertableau
      @onenumbertableau  3 года назад +1

      @@nafiulhaque5585 How about this?
      IF ISNULL([Create Date]) = FALSE THEN 1
      ELSEIF ISNULL([Complete Date]) = FALSE THEN 0
      END