Page tree

Trifacta SaaS



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
Parameter: Formula type Single row formula
Parameter: Formula mindateif(Date, OrderValue > 100)
Parameter: New column name '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
Parameter: Formula type Single row formula
Parameter: Formula maxdateif(Date, OrderValue > 200)
Parameter: New column name '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
Parameter: Formula type Single row formula
Parameter: Formula modedateif(Date, OrderValue > 0)
Parameter: New column name 'Answer'

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

This page has no comments.