M
Michael.Tarnowski
Hi experts,
I have an application to track action item status - "open", "close",
"postponed", and "overdue".
For this I set up the source data to give these info as well the year
and calendar week. This I pivoted and charted to get the amount of
"open", "close", "postponed", and "overdue" items per week/year. It
works well.
Now I want to get a picture how long items remain open, similar to:
http://www.iceincusa.com/16CSP/content/gifs/mm_3.gif
For this I extended my source data and the corresponding PT by the
additional columns "days open" (=TODAY()-showUpDate) and "weeks
open" (=ROUND(daysOpen/7;0) for each item entry.
Example: for an item showed up at 2008-06-17 and being still open, the
days open are 232 and the weeks open are 33.
A pivot chart is showed by http://tinyurl.com/bh2zg4
But, now I want to show the values of "weeks open" as clusters of 2
(or an individual defineable range)
How should I set up my source data / PT? --- Do I need "helper
columns" for each class?
Thanks for your assistance!
Michael
I have an application to track action item status - "open", "close",
"postponed", and "overdue".
For this I set up the source data to give these info as well the year
and calendar week. This I pivoted and charted to get the amount of
"open", "close", "postponed", and "overdue" items per week/year. It
works well.
Now I want to get a picture how long items remain open, similar to:
http://www.iceincusa.com/16CSP/content/gifs/mm_3.gif
For this I extended my source data and the corresponding PT by the
additional columns "days open" (=TODAY()-showUpDate) and "weeks
open" (=ROUND(daysOpen/7;0) for each item entry.
Example: for an item showed up at 2008-06-17 and being still open, the
days open are 232 and the weeks open are 33.
A pivot chart is showed by http://tinyurl.com/bh2zg4
But, now I want to show the values of "weeks open" as clusters of 2
(or an individual defineable range)
How should I set up my source data / PT? --- Do I need "helper
columns" for each class?
Thanks for your assistance!
Michael