Skip to content
Take Off Metrics
  • Pages
    • Launch Pad
    • widgets
      Dashboard
    • Exit Feedback Form
    • Form Results
    • icon picker
      Formulas
    • Tables
Take Off Metrics
/
Formulas
Share
Explore

Formulas

info
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()


Want to print your doc?
This is not the way.
Try clicking the ··· in the right corner or using a keyboard shortcut (
CtrlP
) instead.