Straight table

[mario-sarkis]

hey all

i have a straight table but my pro is i dont want it to be affected by date

when i select the date i dont want the chart to change , but if i select on other field it should be affected.

hope you canhelp thank you,

‌

[Digvijay_Singh]

Try this, it may work based on what dimension you have selected -

Max({<Date=>}if(Date <=today()-2,Date(Date)))

[mario-sarkis]

‌it didnt work unfortunatly

[tamilarasu]

Try this,

Only({<date={"<=$(=Date(Today()-6))"}>}date)

[tresB]

=Only({<date>}if(date <=today()-6,date))

[tyagishaila]

PFA,

Create new Datefield with this expression

Only({<Date=>}Date)

and use this new Datefield in your expression

if(Date1 <= today()-6 , Date1)

[Anonymous]

only function is use for requirement