Tableau: Table Calculations and Time Series Analysis

Posted on Updated on

Using Running total for duplicate SUM(Sales)

Table Calc and Time Series 1

We can see that Corporate is performing best

Table Calc and Time Series 2

Looking at the year on year percent difference in Sales

Table Calc and Time Series 3

Using bar charts to look at the quarterly performance. We can further drill down to more granular levels to check monthly and daily performances

Table Calc and Time Series 4

Looking at every day sales with “Running Sum” and “Moving Average” of Sales

Editing calculations at the date level with “Previous value” as 30 – for the 30 day moving average

Table Calc and Time Series 5

And using filters to see the data for particular years

Table Calc and Time Series 6

At Tableau Public: 

Time Line

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s