How to calculate overdue from specific date and show in pie and table chart

[saivina2920]

I want to calculate overdue from specific date. I want to show this result in Table Chart and pie chart

i have mentioned different overdue in attached excel. 

I have no idea how to proceed the overdue calculations.

pls. find attached excel and let me know if you have any doubts.

pls. help this is urgent and i am waiting for long time.

Note :  KEY column is "Received Date" for process the formula

[parthesh]

Thanks,

yes sure , we can do that.
if you got your resolution can you please mark this as answered.

Regards,
Parthesh.

[saivina2920]

definitely i will do that..
along with the below, i want to add one more condition. I am getting little bit confused where and how to add the below count condition
SQL column (NewDate) condtion
=count(DISTINCT if(Date(NewDate,'dd-mm-yyyy')+GetFieldSelections(SeqDays) - Today() > -5 and Date(NewDate,'dd-mm-yyyy')+GetFieldSelections(SeqDays) - Today() < 0,NewDate))

One more SQL column (EMP_SECTION)
EMP_SECTION= {'*B-*','*C-*'}

earlier i used below formula
=Count({<NewDate={">=$(vIssueCalDate)<=$(vToday)"},EMP_SECTION= {'*B-*','*C-*'}>} DISTINCT EMP_NUMBER)

now i want to add with the EMP_SECTION= {'*B-*','*C-*'} with
=count(DISTINCT if(Date(NewDate,'dd-mm-yyyy')+GetFieldSelections(SeqDays) - Today() > -5 and Date(NewDate,'dd-mm-yyyy')+GetFieldSelections(SeqDays) - Today() < 0,NewDate))

How to add...???

pls. give me combine count...???

If this is through, then my requirement is over...

[saivina2920]

=count(DISTINCT if(Date(NewDate,'dd-mm-yyyy')+GetFieldSelections(SeqDays) - Today() > -5 and Date(NewDate,'dd-mm-yyyy')+GetFieldSelections(SeqDays) - Today() < 0, EMP_SECTION= {'*B-*','*C-*'}, NewDate))

will the above condition work.. i added EMP_SECTION= {'*B-*','*C-*'}.....?

[parthesh · Accepted solution]

You can try
=count(DISTINCT if((Date(NewDate,'dd-mm-yyyy')+GetFieldSelections(SeqDays) - Today() > -5 and Date(NewDate,'dd-mm-yyyy')+GetFieldSelections(SeqDays) - Today() < 0) and (EMP_SECTION like '*B-*' or EMP_SECTION like '*C-*'),NewDate))

[saivina2920]

Thanks Parthesh..It's done.
The below only is suggestions and concern. brcause it's lengthy formula. if we declare some variable and using those variable in count, it will be helpful and we can arrive more condition in expression.
instead of using the lengthy formula, can we use variable and assign those variable in to formula...?
for example,
=count(DISTINCT if(Date(NewDate,'dd-mm-yyyy')+GetFieldSelections(SeqDays) - Today() > -5 and Date(NewDate,'dd-mm-yyyy')+GetFieldSelections(SeqDays) - Today() < 0,NewDate))

var 1 = Date(NewDate,'dd-mm-yyyy')+GetFieldSelections(SeqDays) - Today()
var 2 = Date(NewDate,'dd-mm-yyyy')+GetFieldSelections(SeqDays) - Today()
=count (var1 and var2,newdate) ==> simple formula with variable
pls. reply and update when you are free....
Thanks again.!!!!!

[parthesh]

yes we can do that.
happy that i was useful for you.