I built a Gantt chart with Tableau and will build a dashboard out of it, and the most important date is called the FCS (or FDW, same meaning).
However the FCS date is not known for all projects, at a given time. So I have null values.
I created a field called "FCS date-sort" :
if ([Type] == 'Milestone') AND CONTAINS([newtitle], "FDW")
then [End Date]
where I replaced the null value with a value long past (12/31/2018)
When I sort 'Project name' by this field (with Aggregation = Max), I get the sorting I expect for my 8 projects :
The first 4 projects are sorted according to their FCS dates, then come the projects that had no FCS date.
Now I want to give the user the ability to choose Ascending or descending order.
I created :
- a parameter (Ascending/Descending) and added the parameter control
- a new field, called Sort By FCS :
When I add this field as a row, suddenly I get 4 extra lines : projects for which I had a FCS date are duplicated.
What am I doing wrong ?
How can I achieve sorting of Project name by FCS date through parameter control for my users ?
Thanks if you can help me.
Your FCS Date creates two dates for your projects - those that have FDW in [newtitle] and those that don't. How should your data handle this? Should it be that if there is an FCS date, it should be assigned to the whole project? Or do you want to filter the sheet so that it only shows [newtitle] having FDW?