About andrehl

andrehl · ‎08-07-2018

It worked like a charm! Thank you so much! May I know where can I get all the XML references from?

andrehl · ‎08-07-2018

sorry, it didn't work for me

andrehl · ‎08-07-2018

Hi @niketnilay, thank you for the feedback! Please pardon my unfamiliarity with programming languages. My data came from excel files, similar to this: Date_created 2017-05-13 2017-05-14 2017-07-14 2018-01-05 What I want to do is for the user to select filters (combination of both), Year: 2017 Month: 06 , and Duration: Past 6 Months and my dashboard is supposed to only show datas from 2017 January to 2017 June .

andrehl · ‎08-07-2018

my apology, I forgot to mention that my Time Range has to be an 'All Time'. Using your method, I can't seem to make it wait 'til the end of my search query.

andrehl · ‎08-06-2018

Hi Community! I would like the filter named [Total Distinct Customer in 2017 //ignore and Total Distinct Customer in 2018 //ignore] ,as attached in the picture, to fill itself with the number in the single value panel without having the user to click on it. Thanks before!

andrehl · ‎08-06-2018

you, sir, are a genius. thank you so much!

andrehl · ‎08-02-2018

Hi community! I would like to make the number inside the red circle to be a percentage based on the total customer in the blue box. The code for the chart is: ... |eval date_transfer=coalesce(date_created_tfo,date_call) |join sku_name [search index=index_products_production |eval group_name=if(isnull(group_name),"NUL",group_name)]</code> |eval year=strftime(strptime(date_transfer, "%Y-%m-%d"),"%Y") |search group_name!="NUL" |chart dc(customers_name) by group_name year While the code for the distinct customers is: ... |join sku_name [search index=index_products_production |eval group_name=if(isnull(group_name),sku_name,group_name)] |search $country$ |stats dc(customers_name) as "Number of Distinct Customer"

andrehl · ‎07-31-2018

Hi Community! I wanted to create a dashboard that have TWO filters assigned to a graph. Date: Duration: 2018-08-01 6months My graph x-axis: 2018-03 2018-04 2018-05 2018-06 2018-07 2018-08 Be informed that I do not utilize the built-in Splunk _time system and thus I cannot use the _time input provided in the filter. I tried using this as my filter code: - strptime("0000-06-00","%Y-%m-%d") but it didnt work. Thanks guys!

andrehl · ‎07-17-2018

Is it still possible to sort if we have characters under eval command?

andrehl · ‎07-13-2018

Hi guys, Currently, my data is grouped like this: 1. Product | 2018-5-5 02:00 | 2018-5-5 02:30 | 2018-5-5 04:00 | 2018-6-5 02:00 2. asdf | 5 | 6 | 7 | 5 I want to change my data such that it will group by month 1. Product | 2018-5 | 2018-6 2. asdf | 18 | 5 .. This is my code: index=asdf |chart eval(round(dc(customers_name) / 74086 * 100,2). "%") by sku_name month Helpp..

andrehl · ‎07-12-2018

index="stage" |stats dc(customers_name) as "Distinct Customer" by sku_name sku_number |rename sku_name as Product sku_number as ID |eval Rate=""Distinct Customer" / count(customers_name)"."%" Hi guys, I'm trying to calculate the percentage of the customer involved with respect to the grand total number of customers but I cant seem to use count under eval. Any help? Thank you!

andrehl · ‎06-20-2018

Hi, I wanted to integrate Tableau to Splunk. I have searched for tutorials and installed Splunk ODBC to my computer. However, every time I tried to connect to Splunk from Tableau, there is this exclamation mark appear next to the data source saying, "There was a problem connecting to the data source '...'. Try editing the data source." I am sure that my username and password are correct. Is there any step that I'm missing? Thanks

andrehl · ‎05-22-2018

@niketnilay, Yes, but without input controls. It will just be a static PDF report

andrehl · ‎05-22-2018

@niketnilay thank you for your response! However, is there any other alternative? Like when using webhook or monitor for example?

andrehl · ‎05-22-2018

Hi community, Is there a way to change how the filter works on the dashboard? I want to create a dropdown filter with a symbol indication that it's a dropdown instead of the usual filter. Thank you

andrehl · ‎05-20-2018

Hi community, I wanted to create a dashboard that can update itself daily. As such, someone will upload a file to the internet, and I want my dashboard to automatically grab the newest file and update itself, then proceed to email me with the latest report (for example yesterday's and last 7 days'). However, I realize that the Schedule PDF Delivery is always greyed out whenever I have any filter on my dashboard. Is there any alternative? Thank you

Posts	16
Solutions	0
Karma Given	0
Karma Received	2
Member Since	‎05-20-2018

Online Status	Offline
Date Last Visited	‎06-05-2020 02:04 AM

How to auto-fill/refresh a filter?

How to get percentage from customer of different r...

Duration Filter without _time

Grouping by month instead of by full date format

Percentage based on Grand Total

Integrating Tableau to Splunk

Customize filter badge

Self-update dashboard with Schedule PDF Delivery

Re: How to auto-fill/refresh a filter?

Re: Duration Filter without _time