table summing overall total

[sgilmoreBBP]

Hi all,

I have a visual table that has 3 columns. columns 1, 2 and 3 are all from the same source table 'Production Stats'. The visusal table retrieves values from the columns but is fitered to show the past 5 days. The date column in the 'Production Stats' table does not include weekends but the main table does. 

I want to add another column that pulls data from another table named 'Factory Flow' for the same dates, however when I drag this column into the table visualisations it is showing me a summed total rather than a daily total. Can someone please tell me where I am going wrong? I'm guessing I need to create a measure to do this? 

[sgilmoreBBP]

annoying when it's that straight forward. Thank you @rsbin 

[rsbin · Accepted solution]

@sgilmoreBBP ,

Assume your Date Table is joined to each of your Fact tables on Date.  If this is correct, then use [Date] from your Date Table in your table visual.  At the moment, the table visual is using Date from Production Stats.

This should resolve the issue.

Regards,