5 Replies Latest reply on Jun 28, 2018 3:35 AM by Katya Parvanova

    How to create independent date field with range from particular date to now?

    Katya Parvanova

      Hi everyone,

      I need to create a dashboard that shows the trend of unsolved tickets over time. If I set a filter with the current status it will show the current status, but I need historical data, I need to count the ticket before the moment it was solved. I think that I need additional data field with start date MIN(created at) and end date - Now. And I need to compare the solved date with every date in this period. Any ideas how can I create such a field? Or other way to do this?