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,

‌

[Kushal_Chawda]

=Sum({<Date>} Value)

[tresB]

Use set in your expression like:

Sum({<DateField>} Amount)

[mario-sarkis]

‌but there is no amount or something to aggregate how can i do it?

[Anonymous]

use only function only({<DateField>} FieldName).....

[Kushal_Chawda]

If you have straight table then you should have expression in your straight table. So in each expression you need to write the set analysis like this

{<Date>}

[tresB]

How does your expression look like?

[mario-sarkis]

‌my expression look like this:

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

[avinashelite]

you can use the only() function  only({<DateField>} pro )

[tamilarasu]

Hi,

Try like below,

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

                    Or

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