Manish answered a renewal rate question for me that has helped me understand broader issue with my data set, and visualizations I need to provide. Below is an example of my data set. As you can see I have many dates. I need to be able to show count of contracts under a given date scenario(s) for a given period of time. For example, I need the ability to display a line chart where my dimension or x-axis is a given time period (days of a week, weeks of month, etc...--not one of the dates listed below), and my expressions are number of contracts with an Acct_Date, Eff_Date, Exp_Date and/or any other date below, equal to that period (day/wk/mo). It seems I need to introduce some sort of global date, but I am not sure of the best way to do this. Number of contracts is 7-10 million over multi-year span and all contracts have all of the respective dates.
Thanks for any direction you can provide.
Gary
Contract_ID,
State,
Price,
List_Date,
List_Exp_Date,
Acct_Date,
Pymt_Method,
Pay_Plan,
Closepay_Date,
Entry_Date,
Eff_Date,
Exp_Date,
Cancel_Date,
Channel,
Source,
