# Date Comparisons in Analysis Workspace

Last update: 2023-05-31
• Created for:
• Beginner
User

In this video, we we will show you how to leverage two date comparison features in freeform tables - ‘add time period column’ and ‘compare time periods.’

Transcript

I’m going to go ahead and add in prior month to this date range. Now add time period column we’ll just add the prior month data. So just those raw numbers. So now we’ll have November orders automatically added in compared to December’s orders or last month’s orders. So this is great. We can already kind of eyeball here and see that our direct channel is down a little bit this month same thing with referring domains and moving on down the list.

The next question that your reader is probably gonna have though is you know instead of eyeballing all this are the numbers just up or down. Give me the percentages. So rather than having them do the math. We can go and add in the the percentages for them via compare time periods. Compare time periods will give you the same options as before. So I’ll choose prior months to this date range again but instead of just adding the the raw number column it’s also going to add and calculate for you the percent change. So we see the same November column from before We have our last month December column here as well And then we’ve calculated the percent change for you. In addition and calculating the percent change we’ve layered in conditional formatting so you can very quickly see if performance is is down or up. So red indicates a decline across all the channels and in terms of orders.

The percent change is a complex calculated metric that we’ve created on your behalf so you can click the little eye here see how it’s been defined. It is a internal workspace metric meaning you won’t see it in your calculated metric component list outside of this Workspace. If you do want to leverage this outside of this particular Workspace, you can make the metric public. And then subsequently you can share that public metric with others.

Additionally if you don’t like the percent change name, you can always change that with a little pencil. This is again just a calculated metric that we’ve created for you so you can add in you know month over month percent change if you want to make it a bit more descriptive. Clicking save, that name will be adopted back in the table. -

Date comparisons are an easy way to add depth your current Analysis Workspace tables, and will help you easily put your current data in perspective to historical performance.

For more information on this feature, please see the documentation.