@Sai_Bharadwaj_Venati I really like @Akhtar.shahbaz answer and I'd like to share some additional optimization ideas for you. Rather than putting all your filters in your charting module, you might consIder using system modules. This would be in line with the D.I.S.C.O. method and best practices as outlined by @DavidSmith. Start by creating a system module that has the month selector. Next create another system module that only uses time as a dimension. In our case month. Create two line items, a Boolean, one for months only and set to "TRUE" Create a second line item for the last 3 months and lookup the current period from the other system module. The advantage of doing it this way is that you only calculate the filter once and then reuse it in your chart module which you will see in a bit. Our chart module only contains one line item, the value you want to chart. No filters, lookups, or periods are needed here because we don't want to keep recalculating them for ever month (or product and location if you have those dimensions too). Apply a filter to your chart module from the two line items you created in your system module. Save the view and use this for your chart. When you add the month selector to your dashboard and change it your graph will dynamically change to reflect the last three months.
... View more
