##### Page tree

Release 8.7

Contents:

This example illustrates how you can apply conditionals to calculate minimum, maximum, and most common date values:

• `MINDATEIF` - Minimum of a set of Datetime values by group that meet a specified condition. See MINDATEIF Function.
• `MAXDATEIF` - Maximum of a set of Datetime values by group that meet a specified condition. See MAXDATEIF Function.
• `MODEDATEIF` - Most common Datetime value by group that meet a specified condition. See MODEDATEIF Function.

Source:

Here is some example transaction data:

DateProductUnitsUnitCostOrderValue
3/28/2020ProductA410.0040.00
3/8/2020ProductB420.0080.00
3/12/2020ProductC230.0060.00
3/23/2020ProductA110.0010.00
3/20/2020ProductB220.0040.00
3/12/2020ProductC930.00270.00
3/28/2020ProductA510.0050.00
3/23/2020ProductB820.00160.00
3/16/2020ProductC930.00270.00
3/8/2020ProductA510.0050.00
3/10/2020ProductB320.0060.00
3/13/2020ProductC130.0030.00
3/12/2020ProductA710.0070.00
3/10/2020ProductB720.00140.00
3/24/2020ProductC930.00270.00
3/15/2020ProductA810.0080.00
3/10/2020ProductB520.00100.00
3/10/2020ProductC430.00120.00

Transformation and Results:

These functions are useful for asking questions about your data. In the following, you can review specific questions and see the results immediately.

Question 1: What is the earliest date when a \$100.00 transaction occurred?

Transformation Name `New formula` `Single row formula` `mindateif(Date, OrderValue > 100)` `'Answers'`

Results: Value in Answers column: 3/10/2020

Question 2: What is the latest date when a \$200.00 transaction occurred?

Transformation Name `New formula` `Single row formula` `maxdateif(Date, OrderValue > 200)` `'Answer'`

Results: Value in Answers column: 3/24/2020

Question 3: On what date did the most transactions occur this month?

Transformation Name `New formula` `Single row formula` `modedateif(Date, OrderValue > 0)` `'Answer'`

Results: Value in Answers column: 3/10/2020