Take Off Metrics

Explore

Take Off Metrics

Take Off Metrics

Formulas

Sharing this page for capstone; normally, it would be hidden

Dashboard Date Range Picker

dateRangeStart:

1/1/1

⁠

• [Data Date Range].ToText().split(", ").First()

dateRangeEnd:

12/31/3999

⁠

• [Data Date Range].ToText().split(", ").Last()

isDatePickerEverything:

true

⁠

• [Data Date Range].ToText() == "1/1/1, 12/31/3999"

isDatePickerToday:

false

⁠

• [Data Date Range].ToText() == Concatenate(Today(), ", ", Today())

isDatePickerOneDate:

false

⁠

• [Data Date Range].ToText().Split(", ").CountUnique() == 1

getDateRangeTwoValueString:

from 1/1/1 to 12/31/3999

⁠

• Concatenate("from ", DateRangeStart, " to ", DateRangeEnd)

getDateRangeString:

⁠

• SwitchIf(isDatePickerToday, "today!", isDatePickerEverything, " ", isDatePickerOneDate, Concatenate("on ", DateRangeStart), GetDateRangeTwoValueString)

Form Results

filteredRowsByDate:

@ana @ben @#r14 @#r15 @#r16 @#r17 @#r18 @#r19

⁠

• [Form Results].Filter(DateTime.Matches([Data Date Range]))

averageCustomerService

3.875

⁠

• filteredRowsByDate.[Customer Service Satisfaction].Average()

averageProduct

3.375

⁠

• filteredRowsByDate.[Product Satisfaction].Average()

averageCustomerComeback

4.25

⁠

• filteredRowsByDate.[Return Likeliness].Average()

Subcription plans

mostCancelledPlan

@Enterprise

⁠

• [Form Results].Filter(DateTime.Matches([Data Date Range])).[Subscription Plan].Mode()

Gallery

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.