I'm using Tableau Desktop, my data are like this:
and I want to build a table like this
KPI, year(date), last value
coffee time, 2015, 8.30
How can I set a calculated field in order to show me the last value available in that year? I tried to do:
But it didn't work and tells me 'can not mix aggregate and non-aggregate', so I did:
But it didn't work too. How should I proceed?