IT Monkey:   Click Here to Help Me Build the Agenda for Upcoming Cireson Webinars!

Work Item filter based on todays date?

Ben_NelsonBen_Nelson Customer Adept IT Monkey ✭✭
Wondering if "Filter" option at the work item sections allow logic based on today's date.  This is very common in a lot of Microsoft tools (Excel, SharePoint)

Example: Show items with value that: Is After / [Today]-7. 


Which would show values 7 days prior from today's date.  This would be helpful for some management and in change management. 

Answers

  • Nicholas_VelichNicholas_Velich Cireson Consultant Ninja IT Monkey ✭✭✭✭
    Hi Ben,

    Although not currently possible in out-of-box grid views or promoted views, you can get close to this via the Dashboard Designer.

    For example, take the following out-of-box dashboard as an example:


    This is configured as shown here:



    By using the @createdFilter tag in your Query and by clicking "Enable Chart Filtering," you can add the control to filter your dashboard based on a relative date.

    To get started with this, create a new dashboard page, and insert a "SQL Table Widget." More information on this topic is available on our Knowledge Base as well.

    Thanks,
    Nick
  • Brian_WinterBrian_Winter Customer Adept IT Monkey ✭✭

    I'd like to customize this list. I need Last Month but would also like a date Range.


    Thanks!

Sign In or Register to comment.