Before I go to the trouble of attaching a workbook/editing the info to make it public, I wondered if anybody has any quick tips on my problem below:
I want to create a stacked bar chart in tableau, however, within one section of the bar chart I want the latest date for all records to be counted and in the other section, all other dates for records associated with the dimensions in the bar chart.
I have worked the information up in Alteryx and have applied a record ID to the output, but I am struggling on developing this output in Tableau.
Many thanks in advance.
Write a calculated field that divides this into two groups. One is the max(date) or max(dataentry) and the other excludes the max entry.