Show the last records from a date selection on the last 10 days

[suzel404]

Hi all,

How can I see all tickets open and the number from date selected on the last 10 days ?

Is it better to have this in script or in the expression layout ?

Thank newly for your help.

[its_anandrjs · Accepted solution]

New update for the expression

for last 10 days record you can use

>= Date(Max(Date-10)) <=  Date(Max(Date))

Write a SET expression like

=Count({$<Date = {">$(=date(Max(Date)-10)) <=$(=date(Max(Date))) "}>}  Actions)

Regards

[tresesco]

Take a straight table and use expression =Only({<Date={">$(=Max(Date)-10)<=$(=Max(Date))"}>}Actions)

like in attached sample.

[sujeetsingh]

Declare a variable and limit dimension based on it

[#5]

Check the attached