I have create a quarterly series of employment
(e.g., Employment Average = SUM([Employment])/COUNTD([Month Year])),
and have create a growth rate
using Employment Average Growth = ZN([Employment Average])/LOOKUP(ZN([Employment Average]), -4) - 1
I would like to create a histogram (Bins) from all historical growth rates. is this possible?
Hi Darnell,
Making "Bins" out of Table Calculations
would become a nightmare very soon.
Are you going to get a QoQ comparison?
Or you're trying to make it as 3-month moving average?
The former "step" is a quarter, the latter is a month.
There are ways to get these metrics (growth rates)
as Dimensions ("before" any Table Calcs).
Please come up with the sample data
(or even model using Sample Superstore),
I'd like to help.
Yours,
Yuri
