Widget showing value for 4 months ago

@Jef Vanlaer bumping this to the top for more visibility. 

@sai_ram Thanks. In the meantime, I have implemented my workaround using calculated fields on the object (which was easier than I thought it would be), but I'm still interested to see if anyone sees other (better?) options.

How about 2 different filters on the same field? 

Filter 1 → Date > 3 months ago AND 

Filter 2 → Date < 5 months ago

@rakesh You're right. That would provide the right data, but it would be pretty hard to adjust by end-users. Also, I wanted to have 1 global filter on my dashboard affecting all the widgets, which is a lot harder in this way.

Understood it Jeff, however, we are in the direction of simplifying options - including consolidating date literals. Even usage data suggests that ~98% of the filters are on 5 date literals only. Given that we might not be able to add another date literal to support this. 

Can you add some more details on what metric/ report you want to show and why 4 months?

Tagging @naveen_ithapu  and @ciarapeter FYI

We are reporting retention numbers for new users who started every month, for example how many are still active after 30 days and 180 days. Obviously, these numbers come in with some delay, so we can only report on them after a couple of months (depending on the metric and the usage frequency of the software).