topic Re: How to have the best dropdown + OR statement? in Dashboards & Visualizations

How to have the best dropdown + OR statement?

kwanx — Mon, 29 Jan 2018 18:35:17 GMT

Hello - assistance please.

Looking for best way to have an OR statement for "choice value" in drop down config.

Similar to this, but this does not work:

<input type="dropdown" token="location">
        <label>location</label>
        <choice value="*">ALL</choice>
        <choice value="BLTMMD*" OR "WASHDC*">site_1</choice>
        <choice value="BFLONY*" OR "FLSHNY*">site_2</choice>
        <initialValue>*</initialValue>
    </input>

Re: How to have the best dropdown + OR statement?

davpx — Mon, 29 Jan 2018 18:41:40 GMT

How about this?

<input type="dropdown" token="location">
         <label>location</label>
         <choice value="*">ALL</choice>
         <choice value="BLTMMD* OR WASHDC*">site_1</choice>
         <choice value="BFLONY* OR FLSHNY*">site_2</choice>
         <initialValue>*</initialValue>
     </input>

Re: How to have the best dropdown + OR statement?

marycordova — Mon, 29 Jan 2018 19:24:27 GMT

Assuming you have a dashboard and you want to provide a dropdown that defaults to everything or allows the user to select an OR separated list of possible values you could use the following:

  </search>
  <fieldForLabel>title</fieldForLabel>
  <fieldForValue>id</fieldForValue>
  <default>*</default>
  <valuePrefix>scenario_id="</valuePrefix>
  <valueSuffix>"</valueSuffix>
  <delimiter> OR </delimiter>

This is what this looks like in the WebUI:

Re: How to have the best dropdown + OR statement?

marycordova — Mon, 29 Jan 2018 19:30:24 GMT

Here is what this looks like in the finished Dashboard:

Re: How to have the best dropdown + OR statement?

kwanx — Tue, 30 Jan 2018 00:37:45 GMT

davpx - thx for the reply, this worked! I was close, just wrong syntax 🙂

Thanks again!

Re: How to have the best dropdown + OR statement?

kwanx — Tue, 30 Jan 2018 00:40:05 GMT

hi marycordovacaa - this looks like it would work as well if I had many "OR" statements - this this case i have only 2 OR 3 per site (and only 9 sites) so since my options are simple, will go with davpx solution above, but will keep yours in mind if i have a more complex matrix of options.

Thx for the reply!