Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I need help with a KPI that shows the number of visits that must be made during the day.
This line works perfectly for me: Count ({$ <statements-request = {'AGENDA'}, technical-date = {'2018-02-16'}>} idsolicitudposventa),
but when replacing '2018-02-16' with Today () it stops counting and I need it to update itself.
Nope, but i tried this and...BINGO!!!
sum({$<statements-request={'AGENDADA'}>} if(technical-date=Today(),1,0))
Thanks!!
Try using Date(Today(),'YYYY-MM-DD')
I replaced my line for:
Count ({$ <statements-request = {'AGENDA'}, technical-date = Date(Today(),'YYYY-MM-DD')>} idsolicitudposventa) and it stop counting...
If technical-date is of type date then this should work -
Count ({$ <statements-request = {'AGENDA'}, technical-date = {"=$(=date(today())"}>} idsolicitudposventa)
Count ({$ <statements-request = {'AGENDA'}, technical-date = {$(=today())}>} idsolicitudposventa)
Thanks I tried but it doesnt work...
Thanks but it doesnt work...
Hi
You could try DaysAgo
It would need to be done in script
Today() - Date as DaysAgo,
then DaysAgo = {0} for today
or use an 'if' if you can't get it to work. I feel like throwing my computer out the window when simple date set analysis like this won't work. But monthsAgo and DaysAgo (or using an if statement instead) always works for me
can you try this
Count ({$ <statements-request = {'AGENDA'}, technical-date = {$(=floor(today()))}>} idsolicitudposventa)
your technical-date is timestam or date?
may be this
Count ({$ <statements-request = {'AGENDA'}, technical-date = {$(=floor(Date(Today(),'YYYY-MM-DD'))}>} idsolicitudposventa)
It counts but throws me 0, when the output should be 3