I've a requirement to display crosstab with everyday data (displayed based on "Date value")...
This I'll lookup from a Data table, but this table might not have every day date value (which means record might be missing for a day or two)..
I need to show Default value as zero for that missing date record...
appreciate any sagesions and advices
Have you taken a look at the second option in this article:
Show Records That Fall Within a Period of Time | Tableau Software
Another option is to use a LOOKUP() function similar to the article here:
Populating Empty Cells with Zeroes or Existing Data | Tableau Software
Hopefully this helps!
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...