Splunk Search

How to display a table of sales orders, and another table below with details of the sales orders in the same dashboard?

722624
Path Finder

I have to show results like below in a dashboard.

For example:
1) first table shows all the sales orders, as of now system has two sales order
2) then I need to show below the sales order table, something like:

Details of sales order 1001
.....
.....
....
Details of Sales order 1002
.....
.....
....

Can someone please explain how can I show this?

Thank you In advance

0 Karma

gokadroid
Motivator

If you need two tables, please try to use two panels. One panel should give you all the sales orders with a query like:

index=yourIndex sourcetype=yourSourcetype | stats dc(salesOrderNameField) as "Total Sales Orders"

Then for the details of sales order, please check what all fields are available and then table them in a new panel with a query

index=yourIndex sourcetype=yourSourcetype |dedup salesOrderNameField|  table salesOrderNameField, salesOrderDateField, and so on
0 Karma

cmerriman
Super Champion

if the details of the sales orders are on a separate table, you can do something like

base search for sales orders|append [search for details of sales orders]|sort salesOrderId

http://docs.splunk.com/Documentation/Splunk/6.5.1/SearchReference/Append

0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...