Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a button and i am using the action select in Field to exclude the stores that have a specific event.
my expression is the below:
=aggr( | |||||
only | |||||
( | |||||
{< | |||||
Store= E({<eventname={'Momentary Closing of the Shop'}>} Store) | |||||
>} Store),Store) |
so i am excluding the stores that have the eventname 'Momentary Closing of the Shops'
now this expression is working fine when used in any chart as a calculated dimension but not working when used in a button as 'select in field'
any idea?
Hi Malek,
What is your Search String in the Action Property,
Could you please share some screenshots ?
my Field is Store and my search string is the expression that i have posted
=aggr( | |||||
only | |||||
( | |||||
{< | |||||
Store= E({<eventname={'Momentary Closing of the Shop'}>} Store) | |||||
>} Store),Store) |
is eventname a field? where your selecting the value "Momentary Closing of the Shop" ?
at button property>> Actions>> Select in Field >> Field : eventname ; Search string : Momentary Closing of the Shop
then add another button Action: Select Excluded
i cannot simply do that, in fact the eventname is linked to date and store, and what i want to do is to exclude the stores that has this event. however not all the stores have events (regardless if it's momentary closing or not), so if i use the select excluded i will be in fact selecting all the events that are not 'Momentary' and by that i would have been excluding some stores that don't have events at all.