Posts Tagged ‘google analytics’

Bullet Charts in Tableau

February 5th, 2012 No comments

I’ve only just discovered the bullet chart, I’ve had no need to create one until very recently. Both I and my customers find them really useful. They replace the less meaningful ‘traditional’ dashboard tools of guages and dials into something which conveys more information.

The purpose of using them is to compare a value against another value – for example sales this year vs sales last year or order count this year vs budget order count. It compares against the Total of 1 value and the percentiles of that total. In other words it can be seen at a glance if this year is ahead of last year, or to what percentile this year has reached against last year. Read more…

Tableau Display Measures in a Table

September 19th, 2011 4 comments

Displaying measures in a table in Tableau is something that should be straightforward but for some reason I always struggle with it hence I’m writing this blog post. In the Tableau screen at the bottom of the Dimensions section there’s a field called Measure Names and in the Measures section there’s a field called Measure Values. These are the 2 fields that make life easier when displaying data in a table. Read more…

Omniture visits report in Tableau – part 2

This post is a continuation of part 1 on how to create the Oniture visits report in Tableau. Click here to go back to part 1

This is the chart we are trying to create, the same as the Omniture calendar month visits report.

Now we can begin to create the chart. Drag the Day pill to the Columns shelf and the calculated field SelectedMonthVisits on to the Rows shelf. Make sure the Day pill is displaying the DAY(Day). Read more…

Omniture visits report in Tableau – part 1

To recreate the Omniture visits report in Tableau was quite difficult so I’ve broken the post into 2 parts. The result will be published on Tableau Public and I’ll supply the link to the report at the end of the post.

I spent some time recently trying to replicate web traffic visit data from Google Analytics in the style of the Omniture visits report. I like the Omniture visits report as it shows how you’re tracking in the current month vs how you were tracking exactly 4 weeks earlier – i.e. compares Monday with Monday, Friday with Friday, etc. It also shows how you were performing vs last year. Read more…