![]() This value sets a fixed number of rows displayed in the table. In the Global formatting section of the Configuration panel, enter 8 in the Rows displayed field.In the Configuration panel on the right, title your table Most Purchased Games and leave the description field empty. At this point, you've created a new data source and assigned it to a table. The end result is a table with four columns: Game, Purchases, Revenue, and Category. This search adds up the amount of purchases per product, creates a revenue column per product that is made by multiplying the amount of purchases by the price for each product, and sorts the table based on how many purchases were made for each game. | sort -Purchases | rename productName as "Game" categoryId as "Category" | table productName Purchases Revenue categoryId | table productName Purchases categoryId price | stats count as Purchases by productName categoryId price Index=main sourcetype=access_* action=purchase status=200 For this tutorial, copy and paste the following search into the SPL Query field: Name the data source Most Purchased Games. ![]() In the Search section of the Select Data panel, select + Create Search.Select the add chart icon ( ) in the editing toolbar, and then select Table.If you do not configure the field lookups, the searches in the Dashboard Studio tutorial will not produce the correct results. ![]() See About uploading data and Make the lookup automatic in the Search Tutorial manual. The remaining parts of this tutorial depend on you first completing Part 2 and Part 5 of the Search Tutorial. You will query the data using the Splunk querying language called Search Processing Language (SPL). In this part of the tutorial, you will create a table with game revenue and purchases data and adjust dynamic coloring based on the number of purchases for each game. You'll use this to compare revenue and number of purchases by being able to see the values in a cell at a glance based on its color. In Splunk Dashboard Studio, you can format columns in a table visualization by adding dynamic coloring options based on the value within each cell. Let's say that you want to compare the revenue and number of purchases for games sold at Buttercup Games. Part 3: Add a table with column formatting
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |