Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

RE: Track monthly client vist

 

Hi Folks,

I have sample data here. The named clients are supposed to make routine visits in a month. I need help with how I can track whether they have made a vist within a month. 

 

 

I need to visualize it like below on each client report.

 

Your help will be much appreciated. Thanks

 

1 Reply

  • Anonymous ,

    cnt= countrows(Table)

     

    M1= if(isblank([cnt]) , "No", "Yes")