Home Analytics

Reports @Created Filter customization

Brian_WinterBrian_Winter Customer Advanced IT Monkey ✭✭✭

Any way to get Last Month in the list of options for the @createdFilter? Also a Date Range would be handy.

Best Answer

Answers

  • Brian_WinterBrian_Winter Customer Advanced IT Monkey ✭✭✭

    Yes, that helps and I actually use something like that to limit the result set to one full calendar year.

    However, since management needed a dynamic date range, we were driven to Power BI. We can take the same queries (roughly speaking) and add a Date Range filter. This lets management pull up what they need.

    I had once toyed with the idea of presenting a form with Start and End Date fields and then calling the reports with URL parameters. But too much time and too many challenges. Power BI took only a few hours.

  • Shane_WhiteShane_White Cireson Support Super IT Monkey ✭✭✭✭✭

    You could raise a Feature Request for the idea of adding filters to the @createdFilter feature?

    But that makes sense, hopefully that will keep you going with what you need for the time being!

Sign In or Register to comment.