Missing data from secondary datasource - please help

tableaucommunity@tableau.com — Thu, 21 Nov 2013 19:17:02 GMT

Hi all,

I have 2 datasources related via NAME and DATE.

My problem is when I use a summed values from both datasources in one visualisation everything is fine until the point when in primary datasource is no record for particular DATE and NAME and there IS a record in secondary datasource for the same DATE and NAME.

Simply I cannot see the summed value from secondary datasource when there is no row in Primary datasource.

Is there any way how to tell Tableau: Look I'd like to see data from datasource B even if there is no record for this date in datasource A?

Thanks

How to filter lines according to aggregated KPIs

tableaucommunity@tableau.com — Mon, 27 May 2013 09:49:02 GMT

Hi,

I'd like to ask you for help.

I have a KPI table that shows a SUM of "Number of records" for a particular KPI (string Dimension) within relative Date period.

My issue here is that I don't really know how to display only those lines which contains only particular KPI in selected time period.

For example:

On attached picture below I'd like to filter only first two lines with a blue circle (which is one of the KPI - "New Job").

I simply can not figure out how to tell tableau "if the SUM of KPI "New Job" is not null in the view keep the line ELSE hide the line. Any attempt to create this type of calculation ended up with failure because Tableau seems to ignore selected Date/Time period and calculate the sum for the whole datasource where the SUM of KPI "New Job" is never Null.

Hope it makes sense.

See attached packaged workbook

Ladislav

Content in Tableau Community Forums

Missing data from secondary datasource - please help

How to filter lines according to aggregated KPIs