Counting records

[#1]

I have a set of records a user has selected.  I want to take the field due date and count how many records in the current set will happen in 90 days, 60 days, 30 days, and are past due.

Thanks

~Norman Rea

[maxgro]

if I understand,

with a calculated dimension

=if(duedate<=Today(), 'past due', class(duedate-Today(),30) )

and count(duedate) as expression

[#3]

How would this work in a chart not a table.  I have a gauge I am using to display.

[#4]

Here is a image of what I am working with

[maxgro]

stacked horizontal bar chart,

no dimension

4 expression

=count(if(duedate<=Today(), duedate))

=count(if(duedate>=Today() and duedate<(today()+30), duedate))

...

...

also with set analysis instead of if