---
title: "log"
slug: "postfunction-log"
updated: 2022-10-31T08:37:53Z
published: 2022-10-31T08:37:53Z
canonical: "docs.datajet.app/postfunction-log"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.datajet.app/llms.txt
> Use this file to discover all available pages before exploring further.

# log

## Post Function: [log]

### Returns the natural logarithm of the specified measure.

log=Loge.Measure

If measure = 97,825, what power must e (2.7182818) be raised to in order to get 97,825?

log(97,825) = 11.49

or

e11.49=97,825

## Purpose

Use this function to:

- Add a logarithmic scale to a chart
- Manage the display of heavily skewed data

## Calculation

**log= ln(RowX)**

***RowX*** *= value for current row*

***ln****= loge*

***e*** *= 2.7182818*

## Sample Result

![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1634039088366.png)

## Parameters

![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1634039088398.png)

| **Component** | **Description** |
| --- | --- |
| **Dimensions** | Discrete field(s). All fields must come from the same table. |
| **Name** | Name to be displayed as Column Header in result grid |
| **Measure** | The field to be used in the post-function calculation. Must be numeric if Function is anything other than COUNT. Must come from same table as DIMENSIONS. Supports Discrete or Continuous DataTypes. |
| **Function** | COUNT / SUM / AVG / MIN / MAX / STDEV |
| **Post** | **log** |
| ***Value*** | Optional. Filter to apply when evaluating FUNCTION. Only records in the Filter Recordset will be included in the Function and Post-Function calculations. Must come from same table as DIMENSION/MEASURE or be linked to the Dimension table. |
| ***Axis*** | 0 / 1. Y-Axis to use when plotting graph. Default = 0 Log functions are usually plotted on a secondary axis if they are plotted with other data. |
| ***Plot*** | Y / N. Specifies whether measure’s output column should be plotted on graph. Default = Y |
| ***Resolve*** | Optional. Resolve level for the measure. If blank, Resolve = Dimension Table |
| ***Series Type*** | Default / Bar / Stacked Bar / Line / Spline / RangeLow / RangeHigh / CSLow / CSHigh / CSOpen / CSClose Determines the graph style for the measure. |
| ***Popup*** | Default / None / Extended |
| ***Prefix*** | $ / £ / E / % |

## Usage Notes

{UsageNotesHere}

## Example

NOTE: Measure 1 is included purely for illustration. It is not necessary to include this measure for the calculation to work.

| **Dimension:** | **[transactions].[ywoy]** |
| --- | --- |
| Measure 1 | - Name: =count - Measure: =[transactions].[price] - Function: =sum - Post: = - Value: = | - Axis: =0 - Plot:=Y - Resolve:= - Series Type:=Default - Popup:=Default - Prefix:= |
| Measure 2 | - Name: =log - Measure: =[transactions].[price] - Function: =sum - **Post: =log** - Value: = | - Axis: =0 - Plot:=Y - Resolve:= - Series Type:=Default - Popup:=Default - Prefix:= |
| ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1634039088432.png) |
| ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1634039088470.png) |
|  |  |  |  |