Select + Add column to format and select Revenue - number.In the Column formatting section, follow these steps:.Then, in the color picker below the box, select the checkered white and gray box to change the Background to transparent. In the Global formatting section of the Configuration panel, select the white box next to the #ffffff.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:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |