LinPack-for-Tableau
  • DataViz
  • Templates
  • By Sector
  • FAQ
  • News
  • Offers
User Menu
Create Dashboard

Aggregation Rules

Aggregate rules allow you to summarize or change the granularity of your data. In addition to Tableau standard aggregation rules, LinPack comes with a set of additional aggregation rules to facilitate the definition of Business KPIs.

Avg Working Days between

Aggregation Avg Working Days between ([Date], [Date])

Description
Returns the average number of working days between two dates (the result is a numeric - float) - Excluding Saturday and Sunday

Type LinPack built-in Aggregation

Other Aggregation Rules

On Measures:
  • Sum of
  • Sum of (last period only)
  • Sum of (first period only)
  • Sum of (annualized)
  • Sum of (monthly average)
  • Sum of (from to)
  • Sum of (for New)
  • Average of
  • Average of (last period only)
  • Average of (from to)
  • Minimum of
  • Minimum of (from to)
  • Maximum of
  • Maximum of (from to)
  • Median of
  • Median of (last period only)
  • Median of (from to)
  • Constant Value
On Dimensions:
  • Count Distinct of
  • Count Distinct of (last period only)
  • Count Distinct of New
  • Count Distinct of New (soft)
  • Count Distinct of Ending
  • Count Distinct of Ending (soft)
  • Count Distinct of (from to)
  • Count of
  • Count of (from to)
  • Avg Lifetime of
On Dates:
  • Avg Years between
  • Avg Months between
  • Avg Days between
  • Avg Hours between
  • Avg Minutes between
  • Avg Seconds between

Contact Support

Find Us

  • Lintao SA Avenue Louis-Casaï 81 Case postale 4 1216 Cointrin (Geneva) Switzerland
  • +41 79 509 75 52
  • info@linpack-for-tableau.com
  • Show map

Legal

Terms of service

Contact

Contact us

Newsletter

Subscribe to LinPack newsletter

Copyright © 2019 LinPack by Lintao - All Rights Reserved