Forum Discussion

ADSL's avatar
ADSL
Post Prodigy
3 years ago

Count Visit frequency (Week & Month)

Hi BI Community Team,   I have a table name "Customer Visit Plan -- CUST_VISIT_PLAN".   In this table, we want to find/calcualte how many customer that sales rep input to visit based on frequency...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

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

  • ADSL's avatar
    ADSL
    Post Prodigy
    3 years ago

    Hi Ashish_Mathur ,

     

    We want to see the summary by sales rep as the screenshot below.

     

     

    Please kindly check and help.

     

    Thanks and Regards,