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

aswinb over 10 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 aswinb over 10 years ago

Hey Michael,

Thank you so much. It's working but one more little thing I need. Right now the output I get is like this:

monthValue = 3, yearValue = 2014, number = 1,
monthValue = 3, yearValue = 2014, number = 1,
monthValue = 3, yearValue = 2014, number = 1,
monthValue = 3, yearValue = 2014, number = 1,
monthValue = 3, yearValue = 2014, number = 1,
monthValue = 4, yearvalue = 2014, number = 1,
monthValue = 4, yearvalue = 2014, number = 1,
monthValue = 4, yearvalue = 2014, number = 1,

Can you tell me how I can get the count of 'number' for the same month and the same year. For instance if the month is 3 and year is 2014 I would like to get the count of all the 'number' fields that fall into that category. thank you for help. I deeply appreciate it.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 aswinb over 10 years ago

Hey Michael,

Thank you so much. It's working but one more little thing I need. Right now the output I get is like this:

monthValue = 3, yearValue = 2014, number = 1,
monthValue = 3, yearValue = 2014, number = 1,
monthValue = 3, yearValue = 2014, number = 1,
monthValue = 3, yearValue = 2014, number = 1,
monthValue = 3, yearValue = 2014, number = 1,
monthValue = 4, yearvalue = 2014, number = 1,
monthValue = 4, yearvalue = 2014, number = 1,
monthValue = 4, yearvalue = 2014, number = 1,

Can you tell me how I can get the count of 'number' for the same month and the same year. For instance if the month is 3 and year is 2014 I would like to get the count of all the 'number' fields that fall into that category. thank you for help. I deeply appreciate it.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data