...
Rw ui steps macro | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Go to Data Search search → Explore Your Datayour data and in the finder, select demo → ecommerce → data to access the
First, we want to differentiate the positive results (code 200) from the other error codes. We will use the Decode, switch (decode) operation to create a new column that shows OK for 200 codes and Error for codes different than 200. To do it, select the Create columnfield icon on the toolbar.
Now enter a name for the new column (for example, code200) and select Decode, switch (decode) as the operation. Click New Add argument to add the fields and values that will define the conditions of the operation. The following table describes the 4 arguments we need to add:
Select Create columnfield. The new column will be added to the right of the table. Use the horizontal scroll to locate it. Select its header and drag it next to the statusCode column to facilitate working.
Now click the gear icon on options menu in the toolbar and select Charts → Plots → Histogram. Drag the new code200 column to the window to visualize the amount of OK and Error values. |
You don't need to group or aggregate the data to generate a histogram. However, other charts require generating additional data, such as a numeric field to be used as a metric. For example, you can create a pie chart grouping the data, then aggregating it to create a count column.
Rw ui steps macro | ||||
---|---|---|---|---|
Select the Group icon on the toolbar.
Choose Non-time-based grouping from the drop-down list, then add the code200 column as an argument. Select Group when you're done.
Now click the Aggregate icon on the toolbar to create the count of Error and OK values. The Count operation is selected by default, so just click Aggregate.
Finally, select the gear icon on options menu in the toolbar and click Charts → Diagrams → Pie chart. Drag the count column to the Values field, and the code200 column to the Partitioning field. |