Versions Compared

Old Version 2

changes.mady.by.user Sarah Bigault

Saved on

compared with

New Version Current

changes.mady.by.user Juan Tomás Alonso Nieto

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Rw ui steps macro
Rw step

Go to Data Search search → Explore Your Datayour data and in the finder, select demo → ecommerce → data to access the demo.ecommerce.data table.

Image RemovedImage Added
Rw step

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.

Image RemovedImage Added
Rw step

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.

Image RemovedImage Added

The following table describes the 4 arguments we need to add:

Argument

Value

Description

When

Select the statusCode column from the drop-down list.

This is the column from which we want to take the status code values.

is

Click the pencil icon and enter 200.

This is the first condition of the operation. In this case, we want to transform status codes 200.

transform to

Click the pencil icon and enter OK.

We want to transform status codes 200 to OK in the new column.

otherwise

Click the pencil icon and enter Error.

In the case of codes other than 200, the new column will show Error.

Rw step

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.

Image RemovedImage Added
Rw step

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.

Image RemovedImage Added

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
Rw step

Select the Group icon on the toolbar.

Image Added
Rw step

Choose Non-time-based grouping from the drop-down list, then add the code200 column as an argument. Select Group when you're done.

Image RemovedImage Added
Rw step

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.

Image RemovedImage Added
Rw step

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.

Image RemovedImage Added