Table Widget
Last updated
Last updated
A table widget displays data in rows and columns. Typically, each row and column in a table shows a specific item and its attributes.
A table widget can be used to display events, website activities, and others. For example, if you have various events you want to keep an eye on, instead of creating multiple widgets for each one of them, you can pull these events together in your dashboard using a table widget. It can provide a full picture of your performance.
For example, you can create a table widget to track various events like page views, searches, sessions, users, visits, and more.
Display Sales for specific customers.
track performance across multiple channels.
The table widget comes in handy in various situations. Follow these steps to add it to your dashboard.
1. From within your dashboard, click on the Manage dashboard icon at the top-right.
2. Under Widgets, click on the Table icon.
The Table Widget creation window should pop up. (This is where you set the specifics you want to display on the table). It’s also where you edit the widget if you want to change any of its elements.
The table widget window is not too different from what we’ve discussed under creating tiles.
The first part is the general, where you enter a title and description for the widget.
So for instance, if you want to display traffic referral sources, the title can be Referral sources.
For the description, enter a detailed description that helps you understand what the tile is all about (Referral sources in this case).
The data section is where you choose the type of data you want to display on the table widget.
A view is a predefined query modeled to simplify your reporting. What event/data do you want to display on the widget?
Since we want to track referral sources, the view would be Referral Metrics.
Clicking on open view details will open the dictionary where you can find what the view is all about and the associated dimensions.
What attributes of the selected View do you want to display? Dimension provides more information about the selected event. The dimensions you see will be based on the event/view you selected.
Since we are tracking traffic referrers, we will want to see the referral sources.
The Table widget allows you to choose more than one dimension.
So in addition to the source, we can also display the Pageviews for each source.
Measures allow you to further break down your table and display more information. Measures are often numerical values that can be used for calculation.
Once you select a particular Dimension, you’ll be able to choose any of the related Measures. And just like with Dimensions, you can choose more than one measure.
So we can visualize multiple dimensions on our table widget. Let's display the Average Bounce rate, Average Duration, Total sessions, and total users for each referral source.
What date range do you want to display with the table widget? Set a start and finish date, so the date range is the time in between. You can either choose a predefined date range or select a custom date range.
Since we are tracking traffic referrals, we can decide to see the traffic data for the ‘Last 30 Full days’.
Do you want to compare the data on the table widget with that of another period? If yes, what period do you want to compare it with?
Just like with the date range, you can either choose a predefined period or select a custom period.
Select any of the predefined date range.
Want a select a comparison custom range instead? Follow the steps below.
1. Click on compare.
2. Select Custom from the list.
3. Click on the blank bar by the right. The date selector will pop up.
4. Select the date range you want to cover. you can choose to compare it with the data from June.
In our case, we don’t want to compare the data, so we will select None.
Is there any specific set of data you do not want to display? You can also use a filter to limit data, event, or attribute that is displayed on the table widget.
Let's say we don't want to include traffic sources with no views.
To do this;
Select Pageviews as the dimension.
For the determinant (second tab), choose ‘Greater than.’
For the last tab, enter 0.
So the tile will only display referral sources with at least 1 pageview.
The options section is where you select how you want the data to be displayed.
How do you want the table to appear? In what manner should the list be arranged?
You can leave it at default if you don’t want any specific arrangement. But if you do, what dimension or Measure would you want to use for the sorting?
Do you want it to appear in a descending or ascending order?
For example, there are two dimensions and four measures in our table. If we decide to sort the table by pageviews in ascending orders. That means that the Referral source with the highest page views will appear top, followed by the next. But if we choose a descending order, the referral source with the lowest page views will appear top.
This section allows you to control the size of the table widget. There are several predefined sizes you can choose from including unset, small, default, default wide, wide small, wide and full width.
We will choose default wide.
Now we are all done. Just click Save to add the table widget to your dashboard.
Here’s what our table looks like based on available data.
So we have three referral sources with 1 or more pageviews. You can also see the Average bounce, Average Duration, Total Session, and Total users for each referral source.
