How do I show the number of visits of the day?

[schiappacasse]

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.

[m_woolf]

Try using Date(Today(),'YYYY-MM-DD')

[schiappacasse]

I replaced my line for:

Count ({$ <statements-request = {'AGENDA'}, technical-date = Date(Today(),'YYYY-MM-DD')>} idsolicitudposventa) and it stop counting...

[Digvijay_Singh]

If technical-date is of type date then this should work -

Count ({$ <statements-request = {'AGENDA'}, technical-date = {"=$(=date(today())"}>} idsolicitudposventa)

[zebhashmi]

Count ({$ <statements-request = {'AGENDA'}, technical-date = {$(=today())}>} idsolicitudposventa)

[schiappacasse]

Thanks I tried but it doesnt work...

[schiappacasse]

Thanks but it doesnt work...

[robert99]

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

Relative Calendar Fields

[zebhashmi]

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)

[schiappacasse]

It counts but throws me 0, when the output should be 3