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