Hello Splunk Experts, Lets say i have a table that contains 2 columns as shown below: Name S_no aaa 1 ccc 3 bbb 2 ddd 4 eee 5 fff 6 ggg 1 iii 3 hhh 2 jjj 4 kkk 5 lll 6 mmm 1 ooo 3 nnn 2 ppp 4 qqq 5 rrr 6 Now, I need to sort every 6 rows of 's_no' column and populate the table. Something like this: Name S_no aaa 1 bbb 2 ccc 3 ddd 4 eee 5 fff 6 ggg 1 hhh 2 iii 3 jjj 4 kkk 5 lll 6 mmm 1 nnn 2 ooo 3 ppp 4 qqq 5 rrr 6 Could you please help me with the query? Much appreciated! ... View more

Hi Splunk Gurus, @ITWhisperer  I need your expertise in solving a rather simple issue which is taking lot more hours for me to solve. I'm trying to create a table in Splunk which should display Grand Total under each row and also display Compleion% under "Completed" field. I'm able to achieve the grand total using addcoltotals. However, I'm unable to display the completion% under "Completed" field. Here is how the table should look like:  Name   Remaining   Completed   Alice  25 18  Bob  63 42  Claire  10 7  David  45 30  Emma  80 65 Grand Total: 223 162 Completion%   42.07% percetnage calculation = 162/(223+162)*100 I tried using eval function to calculate the percentage but it calculates for each row in a new field. Can you please help me out? Many thanks. Much appreciated! ... View more

Hello Splunk experts,  I'm pretty new to splunk and I would like your help in forming a query for the following requirement. I would like to create a bar chart for each OEM (total of 5 seperate bar charts widgets since we have 5 OEMs) based on the completion progress of NCAPTest. So, these events will be pushed to Splunk every Monday. The x-axis should show the timestamp(_time) in the following format(YYYY-MM-DD) and the y axis should show stacked bar graph where bottom portion of the bar should show completed count(NCAPTest=Yes) along with the completion percentage and the top portion should show the remaining count(NCAPTest=No). This is how the data looks like: 6 Nov, 2023 events: OEM Model Type NCAPTest Honda Civic Sedan No Honda CR-V SUV Yes Honda Fit Hatchback No VW Jetta Sedan Yes VW Tiguan SUV Yes VW Golf Hatchback No Tata Harrier SUV Yes Tata Tiago Hatchback No Tata Altroz Hatchback No Kia Seltos SUV No Kia Forte Sedan No Kia Rio Hatchback No Hyundai Elantra Sedan No Hyundai Kona SUV Yes Hyundai i20 Hatchback No   13 Nov 2023 events: Honda Civic Sedan Yes Honda CR-V SUV Yes Honda Fit Hatchback No VW Jetta Sedan Yes VW Tiguan SUV Yes VW Golf Hatchback No Tata Harrier SUV Yes Tata Tiago Hatchback No Tata Altroz Hatchback Yes Kia Seltos SUV No Kia Forte Sedan Yes Kia Rio Hatchback Yes Hyundai Elantra Sedan No Hyundai Kona SUV Yes Hyundai i20 Hatchback No   20 Nov 2023 events: Honda Civic Sedan Yes Honda CR-V SUV Yes Honda Fit Hatchback Yes VW Jetta Sedan Yes VW Tiguan SUV Yes VW Golf Hatchback Yes Tata Harrier SUV Yes Tata Tiago Hatchback Yes Tata Altroz Hatchback Yes Kia Seltos SUV Yes Kia Forte Sedan Yes Kia Rio Hatchback Yes Hyundai Elantra Sedan Yes Hyundai Kona SUV Yes Hyundai i20 Hatchback Yes   Any help is greatly appreciated.  ... View more