Allow expressions in Date Range option for analytics

[codygarcia]

Hi,

My suggestion would be to allow Date Range to be more dynamic/customizable. I have a bar graph showing current month scrap. A user used the wrong department code, so I had to fix this field in the table. Since this item was technically “updated” in the current month, the scrap value showed up in the graph. Being able to use an expression for Date Range would’ve prevented this from happening.

Thanks.

[jmlowden]

Similar issue for me, I want to show analytics based on date shipped, but this is not necessarily either the record created or updated date in the current table. I could create a parallel log table for metrics, but this seems like unnecessary duplication.