Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a list of account names (field name: account name). How do I show only the account names where the status = new?
Where is this done in the list options?
Hi Suzan,
You can create a new field from script it self, if the Account Name and Status are coming from single table.
in this case you can use below expression.
if(wildmatch(Status,'New'),Account_Name) as New_Account_Name
Hope this will help.
Regards,
Kaushik Solanki
Add a listbox with Status to your sheet and select the value new in the listbox. That will filter the records on status new. Any table or listbox where you show account names will now show only the account names with status new.
If you don't want that but you want to limit the list in a chart or table you can change your expression. Suppose you have account name as dimension and sum(Sales) as expression. If you change the expression to sum({<status={'new'}>} Sales) then you will only see the sales and thus account names with status new. Another option is to use a calculated dimension like =if(status='new',[account name]) and check the option Suppress When Value Is Null for the calculated dimension. In a listbox you would not choose the field, but the expression =if(status='new',[account name]) to show only the account names with status new.
These are all great options but I wish there was an option on list to just display certain fields based on status - like hitting a select button without actually having to select the button.
Hi,
Please find attached file for solution, hope it helps you.
Regards,
Jagan.
I want to show only one horizontal line for caption?? how it possible in listbox?? data should present inside of horizontal line and my caption should present above horizontal line???
Hi Suzan,
You can create a new field from script it self, if the Account Name and Status are coming from single table.
in this case you can use below expression.
if(wildmatch(Status,'New'),Account_Name) as New_Account_Name
Hope this will help.
Regards,
Kaushik Solanki
Thanks everyone... I created a listbox using expression, not field and put in 'if(wildmatch(Status,'New'),Account_Name)' which worked out super well. It totally got rid of the need for buttons.