This article discusses how Andi tools can be used to quickly prepare a simple result set for creating charts. This result set was created in the Data Selection article.

Open

NOTE: The MONTH label used for the SOLD_ON timestamp - it is functionally incorrect but will become useful in the next step.

Convert the "MONTH" timestamp to "Month of Year' using the Timestamp formatter as shown.

Open

Now you can see that instead of a timestamp which isn't usable, the data has been converted into month names. A new sorting algorithm, available in the column header, will be automatically applied to sort by alphabetic Month Name.

Open

Now sort the data by clicking or Ctrl-clicking on each column. The sorting step is critical when creating charts because it allows the MONTH and ITEM to be sorted when used for the category or legend columns.

Open

If you selected an additional column and formatted the timestamp to create a year value, you can quickly use Quick  Filter (Ctrl-Q) to select only the year 2018 for the chart. You can filter the data using one of the following tools - all of them are discussed in articles within the helpdesk.

• Select a value and then type Ctlr-Q

• Right click on the Column Header and choose Filter Values

• Use the Filter Editor by clicking

Open

Open