Look at data by Quarters in Months

[#1]

Just wondering if anybody could help me look at my data by Quarters for the year. The date format is as follows for example 31/12/2014 so I have figured out how to load the data in separately as Month and as Year separately which helps. But I was wondering if their is anyway I can break this down to be able to view the data quarterly also.

What I have is counting the number of companys signed up each month so I can see the data Monthly and Yearly but I am hoping to be able to see Quarterly aswell.

Attached is an example of the type of data I am using.

[marcus_sommer]

You could use an expression like this:

ceil(num(month(YourDateField)) / 3) as Quarter

- Marcus

[vcanale]

or
'Q' & ceil(num(month([YourDateField])),3) /3&'-'&right(year(YourDateField),4) as QQ-YYYY

[#4]

hi

Do I put this as an expression each time I create a chart?

[ramoncova06]

no both options are for creating the field at script level, if you do not want to modify your script you can use either option without the " as Quarter/as QQ-YYYY" and yes you would have to add it to each chart

[vcanale]

If you need to see regularly the data by Quarters, I suggest to add this line

'Q' & ceil(num(month([YourDateField])),3) /3&'-'&right(year(YourDateField),4)       as QQ-YYYY

in the script when/where you load YourDateField and you'll have 'QQ-YYYY' in your available fields.

Then you can use this field in a ListBox or in a MultiBox to filter the data by Quarters at any time and in any Object (Charts or also TableBox).

[marcus_sommer]

I would do it within a master-calendar: How to use - Master-Calendar and Date-Values

- Marcus

[buzzy996]

PFA,