Calculating License Renewal Statistics

Thanks Greg. Those links are close to what I'm looking for, but not exactly. Let me add some detail to my original post with your suggestions.

Summary:

I have a single table where each row contains a bunch of information about customers. I think the relevant columns in this calculation are the licenseStartDate, licenseEndDate, and licenceType. I'd like to create a dataset and some visuals that indicate how the length (number of days) that a customer has had an active license changed over time, on average.

Sample Data:

https://drive.google.com/file/d/1kxiZ31Ff4H6HT9y4GbJZFa2f8kzY6AX_/view?usp=sharing

Description:

ID: Unique identifier of the customer

licenseStartDate: The date that the license was activated

licenseEndDate: The date that the licenses expired/was canceled.

licenseType: Indicates what type of license this record is related to

Expected Result:

I'm attempting to generate a graph where the X axis are dates for which licenses were created and the y axis is the number of days, on average, those licenses remained active. Possibly grouping the data on the X axis into months or quarters.

Thanks for the help!