Chart with two diferent date field

[#1]

Hi guys,

i have a table with two date informations: Contract Date and Cancel Date. One is the date that a client bought a service and the other is when the client cancel the contracted service.

I want do create a bar chart, that i see: January/2011, the quantity of clients that bought the service and the numbers of clientes that canceled it in this month.

I don´t want to make a chart based on the cancel date field or contract date field, i need to compare the two dates with a third date. Any idea how can i do it?

Thanks!

[giakoum]

Please clarify what you mean i need to compare the two dates with a third date

Compare in what way?

[Or]

Set up a third calendar table, which is not attached to any other tables. Make sure it has a value for every day (even if there are no new contracts / cancellations that day).

I've attached an example file - I haven't done this since set analysis was introduced, so there's almost certainly a cleaner way to do it now, but this should get you moving in the right direction. Note that the tables are partial to save time, but your actual date table should be full, of course.

[giakoum]

count({$<[Contract Date]=[Graph Date]>} [Contract Date])

but count is not recommended, so add something like 1 in your load of each record and then sum it instaed of counting it.

[#5]

I am getting an error when I typed

count({$<[Contract Date]=[Graph Date]>} [Contract Date])

are you sure the syntax is correct.

Thanks