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

2020-03-07T08:31:16+00:00July 18th, 2011|Access|

Today I used Access 2007 for the first time. In the past I was an Access 2000 developer. In Access 2007 found a nice thing for entering dates into a text box. Formatting the text box as a date automatically shows a calendar control. Therefore the user can select a date from the calendar, thereby [...]

Omniture visits report in Tableau – part 2

2020-03-09T14:58:08+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. Begin by putting [...]

Omniture visits report in Tableau – part 1

2020-03-09T14:51:17+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 is on Tableau Public and I’ll supply the link to the report at the end of the post. I tried to recreate the Google Analytics visit chart in the style of the Omniture visits [...]

Tableau DateAdd in Custom SQL Data Connection

2020-03-07T08:38:36+00:00July 9th, 2011|Tableau|

In Tableau calculated fields use the DATEADD function to add weeks to a date. 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 syntax [...]