Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Payment Behaviour

Hi Team,   I want to know the payment Behaviour of my consumers. Consumers make payments every month, sometimes 02-03 times in a month. All payments in a single month to be counted as 01 payment & ...
Tips and Tricks
v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi Anonymous ,

 

We do not recommend to share the report link within this public forum. But actually  We cannot understand your data model clearly, Could you please provide a mockup sample based on fake data or describle the fields of each tables and the relations between tables simply? It will be helpful if you can show us the exact expected result based on the tables. Please upload your files to One Drive and share the link here. Or you can use table using fake sample in your reply.


Best regards,

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

v-lid-msft 

 

Hi,

 

We just wanted to know the consumer payment behavior with the below parameter,

All payments of a consumer in a single month to be counted as 01 payment 

01 to 03 times  - Defaulter

04 to 06 times  - Irregular

07 to 10 times   - Alternate

11 to 12 times    - Regular

 

below is the sample file

https://sislinfotech-my.sharepoint.com/personal/ashraf_khan_sislinfotech_com/_layouts/15/onedrive.aspx?id=%2Fpersonal%2Fashraf%5Fkhan%5Fsislinfotech%5Fcom%2FDocuments%2FCustomer%20Behaviour%2Epbix&parent=%2Fpersonal%2Fashraf%5Fkhan%5Fsislinfotech%5Fcom%2FDocuments&ct=1583500752047&or=OWA-NT&cid=d3ede203-7326-c395-ff1e-680e7629ff38&originalPath=aHR0cHM6Ly9zaXNsaW5mb3RlY2gtbXkuc2hhcmVwb2ludC5jb20vOnU6L3AvYXNocmFmX2toYW4vRVl0WWhmZEo2aVpIcEliM0xzY2pESW9CWG8zYzB4QjFIQmM3dzVKVThZMHg3QT9ydGltZT1sZEdBOWREQjEwZw