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
In the Service, you are utilizing a Content Pack. Content Packs are pre-packaged data models, reports and dashboards. So, work has been done on them to include convenient measures, friendly names, etc. With the Desktop, you are essentially pulling raw data (more or less) and building your own data model, reports and dashboards. I've seen this with the Microsoft CRM Content Pack in the Service versus the data connection in the Desktop as well as a number of other content packs.
It is highly likely that "daysfromtoday" can be recreated in your model in the Desktop but you would have to tell me what "daysfromtoday" does. Is it just a measure that shows that data on a certain date was 10 days ago for example?
Thank you for explaining that.
Yes "daysfromtoday" allows you to only show the data over the last 15,30,90 days or whatever. I can not find that option when I access Google analytic data through the desktop app. Currently I am selecting things like clicks or users and then the year and month of the year under the time option in analytics. Then when I make a report i select the year and month I want and it gives me the last 30 days. However, I have to manually change the month for the next report. The "daysfromtoday" option automatically gives you the data from the time frame from the day you run the report.
THank you so much for the help!
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!!!
