How to change the expression to show the count of id for current day?

[#1]

Hi,

I have table with dimension method and Clear.

the expression is count(ID)

The method have data call, email, notice
Clear have data with condition as If(Clear='Work', Clear)

so, I will get under each method the for work the count of iDs. But what I need is the count of Id on current day. So, how can I change the expression

can anyone suggest me please?

[ashfaq_haseeb]

Hi

Try below

=count({<Date_Field={"$(=date(today()-1))"}>}ID)

Regards

ASHFAQ

[#3]

Thanks. I will get the data for yesterday with this expression so, for today(current day) I would change to

=count({<Date_Field={"$(=date(today()))"}>}ID)

Is that correct?

[ashfaq_haseeb · Accepted solution]

True.

Hi with that expression you will get yesterday data

Yesterday

=count({<Date_Field={"$(=date(today()-1))"}>}ID)

Today

=count({<Date_Field={"$(=date(today()))"}>}ID)

Regards

ASHFAQ

[#5]

Thanks. If I have to add another column value means how can I change today expression. I need to write the condition as

Status='Open' and Status='Further'

I need two expressions as with one Status='Open' and another with Status='Further' for today data.

Please can you help me in this.

[jagan]

Hi,

Try like this

=count({<Status={'Open'}, Date_Field={"$(=date(today()))"}>}ID)

=count({<Status={'Further'}, Date_Field={"$(=date(today()))"}>}ID)

Regards,

Jagan.

[ashfaq_haseeb]

Try below

=count({<Status={'Open'},Date_Field={"$(=date(today()))"}>}ID)

count({<,Status={'Further'},Date_Field={"$(=date(today()))"}>}ID)

Regards

ASHFAQ

[#8]

Thanks.

[#9]

Thanks.