Excel Insert Carriage Return or Bullet Points in a Cell

2011-07-22T10:45:57+00:00July 22nd, 2011|Excel|

In Excel to insert a carriage return in a cell click into the cell, type the first line, press Alt-Enter, then type the next line. There are different ways to do this depending on what you're trying to do exactly which I found in this article: http://www.officearticles.com/excel/carriage_return_within_a_cell_in_microsoft_excel.htm To enter bullet points in a cell you [...]

Access 2007 Calendar control

2011-07-18T18:56:44+00:00July 18th, 2011|Access|

I was developing in Access 2007 for the first time today (I was using Access 2000 the last time I developed in Access) and found a nice thing for entering dates into a text box. If you format the text box as a date it automatically shows a calendar control so the user can select [...]

Omniture visits report in Tableau – part 2

2018-05-08T18:27:56+00:00July 12th, 2011|Tableau, Web Analytics|

This post is a continuation of part 1 on how to create the Omniture 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 [...]

Omniture visits report in Tableau – part 1

2018-05-08T18:39:33+00:00July 10th, 2011|Tableau, Web Analytics|

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 [...]

Tableau DateAdd in Custom SQL Data Connection

2018-05-08T18:33:19+00:00July 9th, 2011|Tableau|

In Tableau calculated fields to add weeks to a date the DATEADD function is used. Confusingly the syntax to write a DATEADD in Tableau calculated fields differs the the DATEADD in Custom SQL. The syntax is DATEADD('week',NumWeeksToAdd,DateToAdd). For example in a calculated field DATEADD('week',4,#1 Jan 2011#) = #29  Jan 2011#. I tried to use this [...]