Hi Renjith,
Thank you for your response. Apology if I was not clear enough.
I don't want to get the min or Max value , I will try to explain the query below:
1.base query >> In my base query , there are fields like,
Status (Active/Inactive),
Supplier (FALSE/TRUE) ,
Originated date (I am extracting year from this field)
2. I have dynamic query to generate the year from the indexed data,
| eval count_status=if(Status="Active" AND year <= cur_year,1,0)
in the above line , "cur_year" value if the year field token value , so this
query is calculating total "ACTIVE" users from start to the year selected.
My problem here is , when I selecting one year for ex. 2016 ,the query is displaying total active user count till 2016 from starting , but if I select 2016 as well as 2018, the eval command is throwing error.
So I want to display total active users till 2016 as well as 2018
Is it possible ?
... View more