Formatting Data

Mammoth allows formatting data for visual convenience without actually affecting the underlying data.

Number Formatting

The following options exist when formatting a number.

1. Number of decimal places.

2. Toggle comma separation.

3. Currency Symbol. This option is mutually exclusive with Show as Percentage.

4. Show as Percentage. This option is mutually exclusive with Show as Currency Symbol.

This option can be reached through

1. The column menu for numeric columns.

2. Task panel for tasks where this is applicable.

3. Add/Edit Metric Menu.

Note that this formatting is just cosmetic. Data is not affected when this is done. For example 3.3333 can be formatted to look like 3. But when you apply a task such as filter, this will not be taken into consideration.

Date Formatting

A list of popular date formats will be listed in this menu. Note that this formatting is just cosmetic. Data is not affected when this is done. For example “2012-12-28 12:39:00” can be formatted to look like “28 December, 2012”. But when you apply a task such as filter, the time part of the data will still be taken into account.