Forum Discussion

Mahmoud_nabir's avatar
Mahmoud_nabir
Frequent Visitor
7 years ago

Date Table with weekday Table

i have created date table and want to find the sum of planned visits during selected date       Date Table     Visits by WeekDay Date WeekDay     visitday planned_visits 4/1/2018...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Mahmoud_nabir

 

I hope you have 2 tables Date Table, Visit by day table.

 

1. Make sure you form the relationship between these 2 tables using the Date.Weekday= VisitbyDay.VisitDay columns , it should be M:1 ( Many end of date, 1 end of Visitday).

 

2. Pull the date ( from data table ) and SUM(visitbyday0 Planned_Visits])  into your visual, you will get the desired result.

 

I hope this is what you are looking for.Let me know if you face any issues.

 

Thanks
Raj

  • Mahmoud_nabir's avatar
    Mahmoud_nabir
    Frequent Visitor
    7 years ago

    Dear rajendran

     

    thanks for your replay.

     

    unfortunately it doesn't work as it result the planned visits for one week only.