For those of us using Quantrix before 2013, we dreamed of timeline functionality. Once we got that wish, we flipped the calendar to new creativity in our model building.
In this brief tutorial, I will show you how easy it is to insert a calendar in any Quantrix matrix. There are also a few Easter eggs to augment your Quantrix skills.
On Your Own Toward Mastery
- Should you include summary totals in an actuals dataset that’s been imported into your model? Why or why not? Is the answer black and white?
- How do you detect a timeline? Now that you’ve seen an example of this feature, how will you use it?
- To timeline or not to timeline? Will you always use the timeline feature in your models, or will you create categories for years and months instead? If so, how will that affect recursive calculations across your models?
As always, let me know if you have a question or want the underlying file for practice purposes.
