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
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
Awesome thank you very much!!!! I just wasnt thinking of it that way. So helpful!!!