Skip to main content

Hello All; I'm using Tableau Desktop 9.2.8.

 

Goal: to display a two bar charts by date. The primary bar chart displays all values, segmented by a specific dimension (in the attached silly sample they are animals); the second "stalactite" bar chart appears directly under it, showing the results over time for that dimension.

It is important that I use Dashboard or Workbook actions (hover or select), rather than parameters.

 

Issue: the filtered results do not align with their reciprocal dates; instead, null dates on the end are discarded and the values are spread.

 

Here's what I WANT to see--  a reversed-axis second graph that allows the user to see how results varied over time...

  Missing Dates, Null Dates: Aligning Incomplete Date Ranges

But here's what I'm getting (more or less):

pastedImage_7.png

 

I know there's a plethora or articles about dealing with null values in dates... and the trick seems so familiar that it's bugging me (Duplicating the data source? Assigning a dummy key? Sigh...). Any words of advice?

 

Many thanks!

1 réponse
0/9000