Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Friends,
I have a line chart object where I am representing last 15 days Max No. of User login. Now when I select a month, for example - June.
By default it is representing from 23 Jun to Previous 15 days record. Now If I select 22 June, Object representing one day data.
Selection Day is 22 Jun - Then from 8th Jun till 22nd Jun. Suppose I select 10th Jun then from 26th May till 10th June data should to represent in line chart object
I need whatever day, I select it should represent last 15 days data from the selection of max day.
For more ref. Please find the attached QV file.
Thanks.
HI,
In your expressions just replace 14 with vInputNumber like below
sum({<CDay=,CMonth=,CYear=,CDate={">=$(=date(max(CDate)-vInputNumber,'dd-MMM-yy')) <=$(=date(max(CDate),'dd-MMM-yy'))"}>}
aggr(if(max({<CDay=,CMonth=,CYear=,CDate={">=$(=date(max(CDate)-vInputNumber,'dd-MMM-yy'))"}>}CDate)<=
max({<CDay=,CMonth=,CYear=>}LicenseDeployDate),max({1}MinNoOfLicense),max({1}MaxNoOfLicense)),NavisionInstance,CDate))
If you got the answer close this thread by giving correct and helpful answers to the helpful posts.
Regards,
Jagan.