We are using a query to get results based on previous month and also date range (dd-mm-yy).. But in our query, we used to get results only for previous month, not for the date range(its not acceptin...
See more...
We are using a query to get results based on previous month and also date range (dd-mm-yy).. But in our query, we used to get results only for previous month, not for the date range(its not accepting the double quotes ("") for the number, when I remove "". its not accepting the string :(.. query we used for reference... Isnum is not working with "", if I remove "". string is not working..pls suggest me the solution, tried different ways but nothing is working.. | eval lnum=if(match("1690848000","^[@a-zA-Z]+"),"str","num"), enum=if(match("1688169600","[a-zA-Z]"),"str","num") | eval latest=case(isnum(1690848000),(1690848000-60),"1690848000"="now",now(),"1690848000"="",now(),lnum!="str","1690848000",1=1,relative_time(now(), "1690848000")) | eval earliest=case(isnum(1688169600),(1688169600-60),"1688169600"="0","0",enum!="str","1688169600",1=1,relative_time(now(), "1688169600")) I want to have same data for previous month and also date range filters...This is question..