I have a system that is heavily workflow dependant. I have a content type called 'Profile' with 3 states :

  1. Lead
  2. Prospect
  3. Customer

I would like to know how to create a views contextual filter of all Profiles that changed to the Customer state in a given month i.e. which Profiles Customer this month. D6 Views 2.x has this option but I cannot find it in D7 Views 3.x



You may want to check if using the Views Date Format SQL module could be a solution for you. Here are some quotes about it (from its project page):

... allows to format date fields using SQL.

The core functionality is to remove the date formatting from render() and put it in query(). I.e. format date values using SQL's DATE_FORMAT rather than PHP's format_date. This is achieved by assigning a new default handler to node 'created' and 'changed' date fields. This handler extends and overrides views's build in views_handler_field_date.

The UI is completely unobtrusive, only a single checkbox "Use SQL to format dates" is added to the handler configuration popup.

Your question is not about creating charts in Drupal, but you may want to refer to this comment also for an example of how we typically use it within the Charts module.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.