Forum Discussion
Google Analytics Desktop vs. Online
So, what you want is to create a new measure (or could be a column) in your data model for whatever table you are dealing with. Let's say you have a table like:
Page Name,Clicks,Date
Home Page,14,11/15/2015
Home Page,13,11/20/2015
Home Page,20,11/25/2015
Home Page,23,11/30/2015
Home Page,5,12/5/2015
Home Page,10,12/10/2015
Home Page,15,12/15/2015
Home Page,12,12/20/2015
Home Page,22,12/25/2015
Home Page,21,12/30/2015
Make sure Date is formated as a date time field and you could create a column in your data model:
daysfromtoday = ROUNDUP(1.*TODAY()-[Date],0)
You could then use that in a filter, slicer, etc.
I actually have a number of potentially useful formulas from my article on building dashboards in Microsoft CRM:
https://www.linkedin.com/pulse/building-ultimate-microsoft-crm-dashboard-under-hour-greg-deckler
I am trying to implement this but I cant seem to figure out where to put the "daysfromtoday = ROUNDUP(1.*TODAY()-[Date],0)" Sorry to be a pain I am not very experienced. Thank you again for your help and time!
Well, in Desktop, go to the second icon on the left that looks like a table. Click on the table on the right that has the Date column in it. Click on "New Column" in the ribbon. You will be placed in the column formula area with a default of "Column = ". Select all of that and replace it with the "daysfromtoday = ..." formula. Hit Enter and that will give you a column called "daysfromtoday" that should show up in your right-hand columns and measures area.
ok awesome thank you!