I have a Dashboard created in Dashboard Studio and have added a simple dropdown to select "Production", "UAT, "SIT',"Development" and it sets a correspnding value that I use in the $api_env$ token as shown below. This works correctly and results in CA03430-cmsviewapi-prodox as I expect. I want to use the value in the $api_env$ token to programmatically change the index between wf_wb_cbs and wf_cb_cbs_np. How do I do that? I tried adding eval idx=if() at the front of my query but when it gets to the existing index= portion it flags an error "Unknown search command 'index' Thanks for any assistance! Here is the query as it now shows in my dashboard: "ds_search_1_new_new": { "type": "ds.search", "options": { "query": "index=wf_wb_cbs CA03430 sourcetype=\"cf:logmessage\" cf_app_name=\"CA03430-cmsviewapi-$api_env$\"| spath \"msg.customerIdType\" \r\n| eval eventHour = strftime(_time,\"%H\") | where eventHour >= \"07\" and eventHour < \"20\" \r\n| stats count by \"msg.customerIdType\"", "queryParameters": { "earliest": "$global_time.earliest$", "latest": "$global_time.latest$" } }, "name": "cmsviewapi_activitybyrole" }, And here is my input: "input_w8NFtYlK": { "options": { "items": [ { "label": "Production", "value": "prodox" }, { "label": "UAT", "value": "uathra" }, { "label": "SIT", "value": "sit" }, { "label": "Development", "value": "dev" } ], "token": "api_env", "defaultValue": "" }, "title": "Environment", "type": "input.dropdown", "dataSources": {} }
... View more
