Discrete time analysis and Quick Table Calculations
1. Discrete time analysis and Quick Table Calculations
Now, we're going to progressively look at trends by the hour, weekday, and on to increase our point of view. We're also going to slice and dice this data by the user type. Let’s start with a histogram. We'll be using start time a lot because it provides the richness of a time and date stamp. So first off, we're going to let it be our X-axis and in the dropdown, we’ll have it show up as the 24 hours of the day. We want it to be discrete so I’m selecting it from the first section of date values, the second section below is for continuous measure date values. Then we’re going to populate it with all the trips that have occurred by taking our counted numbers of rows to the row shelf. and let’s change this from line to bar chart in the marks card. I’ll segment it by user type by bringing user type to the color marks card. And let’s use entire view. Now, I’ll click on the T to show Mark labels, and you can also do that inside this marks card space here, whichever you prefer. To give this histogram more clarity, I’m going to right-click one of the labels. There are a couple useful options here including rotate label. For now let’s go into format. And in this side pane, under dates, I’ll change the style to 12 hours. This is my first viz to give me some insights on hourly patterns and the division between the subscribers and customers. Now for my second point of view, I'm going to be looking at the trends by weekday, so I'm going to use start time again. Bring it onto the column shelf, so it'll be the foundation of the x-axis. This time I'm going to ask it to display as discrete by weekday. Okay, so there's my Sunday through Saturday, I'm going to segment this by user type again, by bringing it to the row shelf. I’ll add the counted rows to the sheet and it’s automatically added to text. This time, we’ll go into the drop-down to apply a quick table calculation for percent of total. Quick table calculations allow us to quickly apply a common table calculation to the visualization. We need to tell the quick table calculation how percent of total should be calculated. Right now, it’s table across, so we get the proportion of rides by weekday. Instead, let’s use table down so that we get the proportion of user types on a certain weekday. Anytime, you see a field with this triangle, that means the field has a quick table calculation applied to it. In a later chapter, we will cover quick table calculations in more depth. I’m also going to have the plain version of counted rows on the table by dragging it again to text. Let’s make this more readable by changing the fit to Entire View. I’m also going to go to the analysis tab to give me some totals. Under totals, I want to see column grand totals. And this new row shows up at the bottom with the total percent and raw values. I'll bring the count again to color to give it some emphasis, and change this from automatic to square so that way there’s color behind my numbers. The shading will give us that additional flare and contrast. For example, we see immediately that subscribers are the high usage users, through the weekdays.2. Let's practice!
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.