Hi All, In my dashboard, I have edit data option. For few multiselect input option the previous value is null, on edit when I select any new value I want to remove that null value from multiselect data. I am using JavaScript to add/ edit records from UI. could you please help to deal with the null values. to remove null values on selection of new data. Thanks! ... View more

Hi Everyone,   below is my query to use thousand comma separator: |inputlookup abc.csv | chart sum(field1) as field1 by field2, field3| addtotals | fieldformat/eval = tostring(field1, "commas").   in the result I am not getting commas in the field1 value. If I alter my query with only 1 field -> field2 or field3 then I get expected result. but I want sum of field by field 2 and field 3. can someone help me with this issue? Thanks, ND. ... View more

Hi All, I am using Javascript file to export splunk data from dashboard to CSV file. Issue I am facing is : for few records where strings are long , data is breaking into next line. I want to wrap those long strings in  " " to stop breaking data to next line. below is my code. could someone please help me to get expected result $('#exportBtn').on('click',function(e){ var searchObj= mvc.components.getInstance("rrc_main"); var myResults = searchObj.data('results',{ output_mode : 'json_rows', count:0 }); myResults.on("data",function(){ if(myResults.hasData()){ var data= myResults.data().fields.tostring().replace("Edit,",""); var rows = myresults.data().rows; $.each(rows, function(row){ data = data+ "\n"; for(var i=0; i< 53; i++){ if(rows[row][i]==="edit"){ continue; } if(rows[row][i]== null){ data= data +"\"\","; }else{ data = data +"\""+ rows[row][i].tostring()+"\","; } } }); Kindly help to wrap long strings in  " "  to read csv in proper format without breaking long strings in next line. Appreciate your help!   thanks, ND ... View more

Hi Team,   I want to calculate the % based on two different tables where I am using addcoltotals to calculate grand total. table 1: A  B  C v1 v2 v3 v4 v5 v6 T1 T2 T3 --- > grand total table 2: A B C x1 x2 x3 x4 x5 x6 T4 T5 T6  -> grand total   I want to calculate : F1 =T1/T4 F2 = T2/T5 F3 = T3/T6   could you please help me to find the solution.   can I store values of T in token and use eval command to calculate the results.   looking forward for the help   ... View more

Hi Team,   could you please help to get below query: I  have 2 lookup files. I want to fetch uncommon data from 1 of the lookup file. e.g. 1st Lookup file - abc.csv ID Name 1 abc 2 xyz 2nd Lookup file PQR.csv ID NAme 1 abc   I want to fetch below uncommon data   output :  ID NAme 2 xyz   Kindly help to get this.   Thanks. ND   ... View more

Hi All,   I want help in multiselect input type. when user starts typing value in multiselect input the suggestions should auto populate.  e.g. when I type Splunk - below results should populate Splunk multiselect spl Splunk enterprise  kindly provide your inputs/ suggestions   thanks, Neha  ... View more

Hello all, I want to add last updated date column in dashboard for KV store lookup. When I am using time () or now() and updating a single row, last updated date get changed for all the records available in the table.   Kindly suggest how to update last updated date (rowwise) for the record update and not the entire table.   Thanks in advance!   ... View more

Hi,   I have below data: Date: Sep 2020 Aug 2018 Feb 2020 July 2017 Sep 2019 I want to sort the date by month and year Like July 2017 Aug 2018 Sep 2019 Feb 2020 Sep 2020     I am using eval strftime function but ouput is coming as Sep 2020  Sep 2019 Can someone please help me to fix this.   Thanks!! ... View more

Hi, I want to combine 3 different source type in single table. The column names are different in all the 3 source type to join them. Eg. Source type = a ID name location Source type = b PID country  Source type = c id contact_number   Kindly help to get output as follows: PID name location country contact_number There are more than 50 column I want in table.   Thank & Regards   ... View more

Hello All, I am new to Splunk and JavaScript as well. I need help to auto-populate the dropdown list value based on other dropdown values selected. consider, I have 3 fields Country, State, City which are interdependent on each other. I am able to populate a dynamic dropdown list(for 2 fields like State & City) on the selection of another dropdown (Country). Now I want to auto-populate values of State and Country on the selection of any City. Values should be directly displayed in the drop-down box. there should not be a need to select it from the dropdown. As for City, State & Country is going to be unique values. Thanks in Advance!!! ... View more