2 Replies Latest reply on Mar 23, 2015 11:16 PM by Matthew Mead

Dynamically charting status change based on dates

Matthew Mead Mar 23, 2015 11:08 PM

Hi,

I have approx 3000 projects with dates below:-

Start date

Finalised date

I want to create a calculated field that will count how many at what status at different points in time.

I'm hoping to make the range/axis dynamic so you can "zoom in" to daily, i.e. 01/03/2015, 02/03/2015, 03/03/2015

and zoom out monthly "01/01/2015, 01/02/2015, 01/03/2015, or even to quarterly 01/01/2015, 01/04/2015, 01/07/2015

Example:-

Start date 21/02/2015

Finalised date 26/03/2015

Status at 01/02/2015 "Not started"

Status at 01/03/2015 "Commenced"

Status at 01/04/2015 "Finalised"

Any help or point to articles/modules is appreciated!

1. Re: Dynamically charting status change based on dates

Sankarmagesh Rajan Mar 22, 2015 10:14 PM (in response to Matthew Mead)

Hi Matthew,

Can you please attach workbook.

thanks
sankar
Like Show 0 Likes(0)

Actions
2. Re: Dynamically charting status change based on dates

Matthew Mead Mar 23, 2015 11:16 PM (in response to Sankarmagesh Rajan)

Hi Sankar,

I've added an example, i had to scrub sensitive information from it.

You'll see the Point in Time Parameter is a one month stepped range.

Ideally i'd like to plot each "status" for each step in the parameters range.

And a way to change the steps to days, months, quarters, years all based on a reference parameter.
Kind of like that, but able to change the point in time dates at the bottom.
Like Show 0 Likes(0)

Actions

Tableau Community Forums