Forum Discussion

ADSL's avatar
ADSL
Icon for Post Prodigy rankPost Prodigy
3 years ago
Solved

Avg. visit plan per day

Hi BI Community Team,

 

I have a table of "Visit Plan" that it's preparing by sales rep and submit to us every month.

 

Follow the working day of the month (e.g. no. working day in July have 26 day), we want to know the avg. visit plan per day by sale rep, sales team.

 

Logic_SR = total no. of visit plan / total no. working day

Logic_Team = total no. of visit plan / total. no of sales rep belong to team / total no. working day

 

Any suggestion/advise?

 

Thanks and Regards,

Need Help

9 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    3 years ago

    Hi,

    Based on the sample table that you have shared, show the expected result very clearly.

    • ADSL's avatar
      ADSL
      Icon for Post Prodigy rankPost Prodigy
      3 years ago

      Hi Ashish_Mathur ,

      Thank you for your feedback. 

       

      May I need your support of this post? the screenshot below, it's the expect result and calculation.

       

      Avg. visit per day should be divide by no. working day when we choose the "Month" slicer. for team, Avg. visit per day should be no. visit plan / total sales rep of team / no. working day.

       

      Thanks and Regards,