Splunk Dev

dropdown

dall
Path Finder

i have one dropdown with month and year how can i separate and make 2 dropdown , one for month another one for year

 

my query is this

| inputlookup ... | search TITLE = "*Microsoft*" OR TITLE = "*Windows*"

| eval new_date=strftime(strptime(PUBLISHED_DATETIME,"%Y-%m-%d"),"%Y %b")
| dedup new_date
| table new_date PUBLISHED_DATETIME
| sort - new_date

0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust

This doesn't sound like the full story!

However, why not create your first dropdown with this query

| inputlookup ... | search TITLE = "*Microsoft*" OR TITLE = "*Windows*"

| eval new_date=strftime(strptime(PUBLISHED_DATETIME,"%Y-%m-%d"),"%Y")
| dedup new_date
| fields new_date
| sort - new_date

and your second dropdown with this query

| inputlookup ... | search TITLE = "*Microsoft*" OR TITLE = "*Windows*"

| eval new_date=strftime(strptime(PUBLISHED_DATETIME,"%Y-%m-%d"),"%b")
| dedup new_date
| fields new_date
| sort - new_date

View solution in original post

ITWhisperer
SplunkTrust
SplunkTrust

This doesn't sound like the full story!

However, why not create your first dropdown with this query

| inputlookup ... | search TITLE = "*Microsoft*" OR TITLE = "*Windows*"

| eval new_date=strftime(strptime(PUBLISHED_DATETIME,"%Y-%m-%d"),"%Y")
| dedup new_date
| fields new_date
| sort - new_date

and your second dropdown with this query

| inputlookup ... | search TITLE = "*Microsoft*" OR TITLE = "*Windows*"

| eval new_date=strftime(strptime(PUBLISHED_DATETIME,"%Y-%m-%d"),"%b")
| dedup new_date
| fields new_date
| sort - new_date
Get Updates on the Splunk Community!

Splunk ITSI & Correlated Network Visibility

  Now On Demand   Take Your Network Visibility to the Next Level In today’s complex IT environments, ...

Leveraging Detections from the Splunk Threat Research Team & Cisco Talos

  Now On Demand  Stay ahead of today’s evolving threats with the combined power of the Splunk Threat Research ...

New in Splunk Observability Cloud: Automated Archiving for Unused Metrics

Automated Archival is a new capability within Metrics Management; which is a robust usage & cost optimization ...