How can I say that in the kpi formula, take the values ​​smaller than the date selected on the button?

[sevvalk]

Hello,

I have buttons. This buttons get the dates example; this year, last year, this week, last week. I want to number of complaints. If the users click the this year button. Kpi calculate the number of complaints received this year and the number of complaints from the previous year that were not investigated. And the happen like that when the users click the this week button. I couldn't do kpi formula. How can I say that in the kpi formula, take the values ​​smaller than the date selected on the button?

[LRuCelver · Accepted solution]

You can use the buttons to set the values for vMinDate and vMaxDate variables based on the button.

In your expression, add a set analysis: {<Date={">=$(vMinDate) <=$(vMaxDate)"}>}

[RamanaKumarChintalapati]

Hi @sevvalk ,

As per my understanding , User wants to  click on Present Year Button  , Present year Complaints will show, Like wise user click on this week button, then KPI need to show this week complaints  

That's it right, any thing missed

Please elaborate your requirement.

Thanks!!!

[sevvalk]

Briefly, how can I write the date selected on the button in the formula?