2 Replies Latest reply on Aug 14, 2017 3:17 AM by Jason Kleinhans

Overdue Customers

Jason Kleinhans Aug 14, 2017 1:52 AM

Good day all

Hope you can assist

I have a view to calculate all customers that are 60 days and over , however I also have customers that is 2 days , 5 days 20 days overdue in the same view which should not be listed in the 60 days overdue view. The customer should only appear when it is 60 days and over

my calculation I have used is

IF DATEDIFF('day', ([Due Date]), TODAY()) > (IFNULL([Suspension Period],60)) THEN "Suspended" // Customers will be suspended if they reach 60 days which is there cut off

ELSEIF DATEDIFF('day', [Due Date], TODAY()) > (IFNULL([Suspension Period],60))-7 THEN "One week before suspension" // Customers that is one week before they get suspended

END

Wines Accounts Receivable Dashboard.twbx 2.0 MB

1. Re: Overdue Customers

Thomas Rones Aug 14, 2017 2:32 AM (in response to Jason Kleinhans)

If i understand your question correctly, then

Create a new measure:

IF MAX([Days Overdue (copy)]) >= 60 then Max([Days Overdue (copy)]) else NULL end

Then just add a filter to exclude the nulls from your viz.
Like Show 0 Likes(0)

Actions
2. Re: Overdue Customers

Jason Kleinhans Aug 14, 2017 3:17 AM (in response to Thomas Rones)

Thanks Thomas , partially it worked , one question though , if the customer reach 53 days will my "one week before suspended" column re-appear in my view , because your calculation removed it
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community

Overdue Customers

1. Re: Overdue Customers

2. Re: Overdue Customers

Actions

More Like This