Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Currently I have an expression in Straight Table in which I am using IF condition :
> if(campaign=' ' and timescale=' ' , date)
But what is happening is if I make selection in the campaign list box then Staright table report will gone.
So , I have to apply the set analysis so that I can by pass the selections .
What would be the expression for this ?
Thanks
only({1<campaign={' '},timescale={' '}>}date)
Hi Gysbert,
I have to provide the name of the campaign and timescale also so that the dates of that particular campaign will come and side by side have to by pass the selections also so that the report will not gone on any selections.
Thanks.
I have this IF condition in the dimensions and the set is not working in dimension . So how to by pass selections in the dimension .
use the set condition in the expression:
e.g. sum({<campaign=,timescale=>} value)
sum function will ignore any selections on the campaign and timescale dimensions
you can also use this in the dimension:
aggr(if(....),date)
instead of the if you can also use an only I dont know exactly what you need but in the dimension you will have to use the aggr() function
hope this helps
regards,
MT
The following expression will also ignore the selections on campaign and timescale
only({<campaign=,timescale=>}date)
Hope this helps.
Thanks
I have tried to use only({ }) in the dimensions of the straight table chart but it is not working.
you have to wrap the only into an aggr function in the dimenisons.
like:
aggr(only({}date),date)
regards,
MT
Did you happen to try this?
Dimension : campaign
Expression: only({<campaign=,timescale=>}date)