The quick answer is ... assign a date to everything
If your data is only at the year level, then you could use 2017 and 2018 as values but realise that Tableau will see that as a number (ie not a date) but you can still make that a dimension. If you use 1/1/2017 and 1/1/2018 Tableau will see that as a date, but you can only show the year part if required - this would also help for quarters and months if you need that detail for some of the other measures.
Lauren Anderson wrote:
Where I run into trouble is prepping this data in excel to be easily transferred and displayed in Tableau. How do I display my date information to account for the different indicators? If I have one column for Year, I don't want this to apply to the indicators referring to a different year. Do I need to create a date column for each indicator?
I'd use a single "time" column for all your measures (aka indicators) and just add rows when you need different years.
You will eventually have data like this:
Country District Year Everyone Reached Community, School & Health Center Projects Completed Community, School & Health Center Projects Planned # of Scale Meetings Held at the National Level # of External Presentations/Articles/Blogs # of Sanitation Initiatives Impact Population Denver 2017 0 0 0 0 UK 2017 0 0 0 0 Bolivia Arani 2017 2 4 10 3 17,894 Denver 2018 3 3 3 3 UK 2018 5 5 5 5 Bolivia Arani 2018 7 7 7 7 18,500
Then you can use "year" in the graphs to show the movement over years.