Showing posts with label duration. Show all posts
January 5, 2022
How to Create a User-Defined Moving Average
analysis
,
calculated field
,
chart
,
comparison
,
context
,
date
,
datetrunc
,
duration
,
how to
,
length
,
moving average
,
parameter
,
string
,
table calculation
,
tableau
,
tip
,
trick
,
tutorial
,
window_avg
,
worksheet
No comments
In this tip, I show you how to use two parameters to create a view that allows the user to pick (1) the duration and (2) the date part to create a moving average calculation.
For example, this technique will allow the user to choose a 13-week moving average, a 6-month moving average, a 90-day moving average, etc.
April 30, 2021
#WOW2021 Week 15 - Workout Wednesday Website Analytics
analytics
,
background color
,
blank
,
containers
,
dashboard
,
duration
,
google analytics
,
layout
,
website
,
Workout Wednesday
,
worksheet
,
WOW2021
No comments
The requirements for week 15 are here. This is another super useful challenge as it helps you develop a dashboard you could easily use in your own organization.
My go-to blog post for working with and formatting time is this one from Jonathan Drummey. I'd say it's critical for solving this challenge. Also, think about the calcs for the reference lines and the BANs. As a hint, they're not just simple reference lines based on the measure on the rows. You WILL need to calculate the overall average separately.
Click on the image to interact with the dashboard and/or download the workbook here.
Subscribe to:
Posts
(
Atom
)
