To achieve your requirement, you need some data reshape. I use pivot your four date fields as shown below as example for your reference.
Here is the reuslt
Workbook attached. hope this helps
Gantt chart_v10.2.twbx 40.4 KB
Many thanks for your answer, that's awesome !
I changed the validity date of aaa and bbb to cover all cases possible :
- aaa : the validity period doesn't overlap with the issuance period
- bbb : the validity period follow immediately the issuance period
- ccc : same as before, the validity period start during the issuance period
- ddd : unchanged ie the validity period start at the same time as the issuance period and last longer
Do you think Tableau can take all these cases into account ? I did a quick drawing of what it should like : (the number of cells vs. number of days is not correct but you get the idea)
Thanks again for your help !
Gantt chart_v3.twbx 48.2 KB