Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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's avatar
    rsbin
    Icon for Community Champion rankCommunity 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,

  • Anonymous's avatar
    Anonymous
    Not applicable

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