Hi All, I have a query rule which takes 2 parameters: a start date an

aswinb over 11 years ago

Hi All,

I have a query rule which takes 2 parameters: a start date and an end date. It will give me a list of items that were created between the start date and the end date. For instance if I pass in (2009/5/1) as start date and (2014/2/3) as end date it will give me an accumulation of values that occured between those dates. I would like to group that data by months. For instance how much values were created in the month of January, February, ....etc between the dates I passed in to the query rule. So far I have been able to get a list of dates like (2009/5/1, 2009/5/3, 2009/5/4, 2009/6/14,....) which denotes that during those dates a value was created. But I want to be able to distinguish the count of values that were created in the month of 2009/5 and 2009/6 ,....etc till the end date. My goal is to create a tempo report and inside that I want to create a bar graph with the list of values as data and months/year as the categories. I have been t...

Discussion posts and replies are publicly visible

Parents

0 venkats533 over 11 years ago

have an array of size 12 initialized to all zeros. write a function that will return 1 for the month index if the date falls in that month. add the array cumulatively for all elements using apply, then at the end you will have an array of 12 numbers assigned with total count for each month.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 venkats533 over 11 years ago

have an array of size 12 initialized to all zeros. write a function that will return 1 for the month index if the date falls in that month. add the array cumulatively for all elements using apply, then at the end you will have an array of 12 numbers assigned with total count for each month.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data