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 below. Normally we count the visit date then we can find the number of visit plan of Month not week that actually they have number of visit in the week too.

 

For Week -- some sales rep add visit freq 2 or 3 time at the same week.

Here is the sample pbix file - https://drive.google.com/drive/folders/104HeZ5Rcvstgb4y9QaSzkNTDWLpGvvXJ?usp=sharing 

 

Any suggestion?

 

Thanks and Regards,

 

Need Help

5 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    Your visit_freq table is missing an index column and it has conflicting buckets.  (the latter can be dealt with if you have the former).

    • ADSL's avatar
      ADSL
      Post Prodigy
      3 years ago

      Hi lbendlin ,

       

      For time/month, it should be as the screenshot below. But time/week, I don't know to add.

       

       

      Please kindly help

       

      Thanks and Regards,

  • 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,