4 Replies Latest reply on Dec 29, 2011 11:07 AM by Sarah Jabon

    Show Missing Values - Aggregate by Week

    Sarah Jabon

      The new feature "Show Missing Values" combined with "Hide (Break Lines)" is exactly what I need. Thanks for this feature! How do you get a graph that is by week or by month to behave correctly, though? When I aggregate by week, the lines turn into dots. This makes sense, because DATETRUNC is just putting the same date for all the values that week, leaving missing data in the other dates which I just told Tableau to hide and break the lines... but I'd like a line graph by week that shows missing values with completely empty weeks hidden but the other weeks connected with a line. Attached is a jpeg and a workbook.

      Thanks much!