9 Replies Latest reply: Aug 9, 2012 4:09 AM by Dimitris Charalampou RSS

    Chart with Date difference in days

      Hi there,

       

      I have bunch of data (customers) that contain the date that they where last updated (changed address, password etc etc). I also have another table that displays the transcactions of these customers( with a date field of each transaction). i want to create two bar charts that will show me how many of my records have a date difference in days between today and the date that i mentioned before. The records have a unique key but have a one to many relationship. (One customer, many transactions records).

       

      In the first I want to diplay the count of the customers that have a date of update:

       

      UP TP 2 DAYS
      UP TP 7 DAYS
      UP TP 30 DAYS
      UP TP 90 DAYS
      UP TP 180 DAYS
      UP TP 365 DAYS
      UP TP MAX DAYS
      NO ACTIVITY

       

       

      In the second i want to display the count of customers that have a latest date of transaction:

       

      UP TP 2 DAYS
      UP TP 7 DAYS
      UP TP 30 DAYS
      UP TP 90 DAYS
      UP TP 180 DAYS
      UP TP 365 DAYS
      UP TP MAX DAYS
      NO ACTIVITY

       

      Thank you in advance guys!