how can i visualized my 2023 parameter on tableau after i have found the year different

43 Views Asked by At

Tableau visualization

i tried this but 2023 column did not calculate rather just giving out negative values in tabeau COUNTD(IF [Year] = 2013 THEN [Name] END) - COUNTD(IF [Year] = 2023 THEN [Name] END) + COUNTD(IF [Year] = 2014 THEN [Name] END) - COUNTD(IF [Year] = 2023 THEN [Name] END) + COUNTD(IF [Year] = 2015 THEN [Name] END) - COUNTD(IF [Year] = 2023 THEN [Name] END) + COUNTD(IF [Year] = 2016 THEN [Name] END) - COUNTD(IF [Year] = 2023 THEN [Name] END) + COUNTD(IF [Year] = 2017 THEN [Name] END) - COUNTD(IF [Year] = 2023 THEN [Name] END) + COUNTD(IF [Year] = 2018 THEN [Name] END) - COUNTD(IF [Year] = 2023 THEN [Name] END) + COUNTD(IF [Year] = 2019 THEN [Name] END) - COUNTD(IF [Year] = 2023 THEN [Name] END) + COUNTD(IF [Year] = 2020 THEN [Name] END) - COUNTD(IF [Year] = 2023 THEN [Name] END) + COUNTD(IF [Year] = 2021 THEN [Name] END) - COUNTD(IF [Year] = 2023 THEN [Name] END) + COUNTD(IF [Year] = 2022 THEN [Name] END) - COUNTD(IF [Year] = 2023 THEN [Name] END) + COUNTD(IF [Year] = 2023 THEN [Name] END)

This what i got

This is what i expect to achieve

0

There are 0 best solutions below