Forum Discussion

ADSL's avatar
ADSL
Icon for Post Prodigy rankPost 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
Icon for Super User rankSuper 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
Icon for Post Prodigy rankPost 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,