Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Friends/Colleagues,
I will feel much obliged if you please provide Date Function to calculate the following.
How can I accomplish the following by each YEAR (2011 - 2012) and MONTH ( 1-12) on a Bar Chart?
Q1. Aggregate/Sum of "No Of Hits" for the "Previous Day"? E.g. Assuming today is 12/20/2011 it would be "6"
Q2. Aggregate/Sum of "No of Hits" for the "Month to Date"? E.g. Assuming today is 12/20/2011 it would be "18"
Q3. Aggregate/Sum of "No of Hits" for the "Year to Date"? E.g. Assuming today is 12/20/2011 it would be "21"
Date | No Of Hits |
---|---|
11/18/2011 | 1 |
11/19/2011 | 2 |
12/1/2011 | 3 |
12/5/2011 | 4 |
12/18/2011 | 5 |
12/19/2011 | 6 |
12/20/2011 | 0 |
Thank You. Happy Memorial Day
MBBS
Note: Please see attchment for more example
First, you need to create a master calendar, i.e. an additional table with all date attributes. See more here and search on the forum for a master calendar.
Secondly, you should create a field "DagsAgo" in your master calendar, that you can use for your first question. See more here.
Thirdly, you should create flags in your calendar, e.g. "IsInYTD", that mark whether this day is within the year/month to date. See more here or search the forum for ytd or yoy.
HIC
Dear Mr. Cronström,
I highly appreciated your quick response. I will look into your suggestions
and make a sincere effort to solve my problem.
I am really happy to take a note of the fact that this community is
really/truly active and someone is always out there to look into unanswered
questions/issues and ready to help.
Thank you and may GOD bless you.
With Kindest Regards,
Sam David
On Mon, May 26, 2014 at 3:08 PM, Henric Cronström