You can add one formula. This is typical formula to make null to zero.
then it still shows this.
Then "show missing value"
If you change the granularity to hour
BTW, I could not find any value in your file?
Missing_Date_SM_9.2.twbx 34.1 KB
Thanks Shinichiro. This solves my issue.
You are welcome.