Skip to main content

Hello!

 

I am trying to figure out what would be the best way to approach creating this executive summary level dashboard that shows

 

 How successful we are at paying vendors that reached threshold  (ex. sales>100 USD monthly) and qualified for a payment on time  (Late payment meaning vendor was above the threshold however payment was issued  >30 days later)

 

I have credit slips with unique ids per vendor with their unique ids generated on a monthly basis. I would like to create a view similar to the image in the attachment, that will show

 

Total Credit Slips created this month for overall all vendors

 

How many of these credit slips/vendors were eligible for payment

 

How many of these credit slips/vendors were not eligible for payment

 

How many credit slips or % of them were paid on time

 

Would appreciate any kind of input, or a tip to get me started somewhere.

 

Cheers,

 

Tuor

 

Need help with logic/method visualizing data of

1 answer
0/9000