Handling Missing Values in Line Graphs

tableaucommunity@tableau.com — Wed, 17 Apr 2019 19:48:27 GMT

Let's say I want to show a line graph of Sales by Date and Product (Coffee and Tea). There were no sales for Tea in February so there's no data in the database. Tableau creates a line connecting January and March Sales (see attached workbook) thereby implying there were some sales in February.

Even if I filter Sales to Non-null value the graph stays the same, but if I keep only the product with missing data (Tea) then Tableau displays January and March only. This seems inconsistent because the display of one product shouldn't be affected by whether other products are included in the view (except for scale).

P.S. Sorry if this issue was already discussed.

Dimension hierarchy, dashboard filters and focus

tableaucommunity@tableau.com — Tue, 11 Feb 2014 13:54:58 GMT

1. Having dimension hierarchies is great: it lets you drill down and roll up, you get performance gains, information is presented in a more compact way, and so on... It's a shame that they are available only for dimensional data sources. Why not enable Tableau users to create hierarchies from relational data? Instead of having two dimensions: Product level 1 and Product level 2, we could just say that the latter is a child of the former and treat it as one dimension. Then we could drill down and roll up just as we do with Date fields. We could expand just those member of a dimension that we want instead of the whole dimension. We could also have hierarchical filters with a tree control.

2. Dashboard with quick filters are a great feature. Often you want one filter to control more sheets on the dashboard. This can be done with a global filter, but sometimes you don't want that. You want a filter on a dashboard level.

3. Reader has no "Clear manual sizing" option so when you use the focus tool the only option you have to get back to the original view is the undo, which is not very logical. And if you do anything after the focus such as filtering, you need to undo those operations first.

Content in Tableau Community Forums

Handling Missing Values in Line Graphs

Dimension hierarchy, dashboard filters and focus