Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
=Sum({<Date>} Value)
Use set in your expression like:
Sum({<DateField>} Amount)
but there is no amount or something to aggregate how can i do it?
use only function only({<DateField>} FieldName).....
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>}
How does your expression look like?
my expression look like this:
=if(date <=today()-6,date)
you can use the only() function only({<DateField>} pro )
Hi,
Try like below,
=if(date <=today()-6,Only({<Date>}date))
Or
=if(date <=today()-6,Only({<Date= >}date))