Forum Discussion
table summing overall total
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?
Anonymous ,
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,
2 Replies
- rsbin
Community Champion
Anonymous ,
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,
- AnonymousNot applicable
annoying when it's that straight forward. Thank you rsbin