About tzvikaz

richgalloway · ‎07-06-2022

It would help to know what you've tried so far, but perhaps this will help. <<your search>> | eval detractor=if(score<7, 1, 0), promoter=if(score>8, 1, 0) | stats count, sum(detractor) as detractors, sum(promoter) as promoters by company | eval NPS = (promoters*100/count) - (detractors*100/count)

splunk0 · ‎04-26-2021

OK, got it to work like so: index=someindex action=someaction |join event_city_id_field [|dbxquery query="select city_id from Cities where Country="USA" connection="SQLserver" | rename city_id as event_city_id_field| fields event_city_id_field] I needed to add the join directive + replace "search" with "|" Really appreciate your help!

tzvikaz · ‎12-31-2020

I have a dashboard that just shows a table of the results. Query is built with parameters taken from TextBox. I would like to take them from the DatTime Picker but it seems to apply only to regular indexed events. Any way to just use it insert SQL formatted DateTime to my dbxquery?

Posts	8
Solutions	0
Karma Given	2
Karma Received	0
Member Since	‎11-14-2011

Online Status	Offline
Date Last Visited	‎07-06-2022 10:22 PM

Calculate NPS (Net Promotor Score)

dbconnect results as a subquery

Use datetime picker as input for a dbxquery

Re: Calculate NPS (Net Promotor Score)

Re: dbconnect results as a subquery

Use datetime picker as input for a dbxquery