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

Labels (1)
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!

Webinar Recap | Revolutionizing IT Operations: The Transformative Power of AI and ML ...

The Transformative Power of AI and ML in Enhancing Observability   In the realm of IT operations, the ...

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...