Formula to Count some object and display it by months for a year

[maolsen]

I am trying to create a formula that can count helpdesk tickets and display them in a chart by month for a whole year.

 

[lbass]

You need to explain what you have tried and what problem you are encountering. It would help if you let us know what fields you are working with.

-LB

 

[maolsen]

I am getting months to figure out based on todays date but My months are off. For example July 10 to June 10 is one month but tomorrow my month will be July 11 to June 11.

first formula
(({HelpDesk.Status} = 5 or{HelpDesk.Status} = 4) and
({@H_ConvertResolvedtoDate} >= DateAdd('m',-12,CurrentDate) and
{@H_ConvertResolvedtoDate} < CurrentDate))

Time formula

(DateTime(1970,1,1,0,0,0) + ({HelpDesk.Resolved_Time})/86400)

We are working in Remedy so we have to purform the Unix conversion.

 

[lbass]

Why are you using today's date to determine a month instead of using actual months? What do you mean by your months are "off"? You need to provide more detail and explanation.

-LB

 

[maolsen]

My months are off as they do not go June first to June 30 or May 1 to May 31. My Months go from what ever day is today to the corresponding day the previous month and sets that as current month. As far as your question about actual months. How do I determine actual months that will fix my whole issue.

 

[lbass]

Using the advanced chart option, you just need to add your date field as the "on change of" field in the chart and then click on "Order" and select "print on change of month".

-LB

 

[maolsen]

The problem with performing that is that all of my dates are in UNIX time which which is all the seconds sinc January 1, 1970. Unless I am missing something?

 

[lbass]

I thought you had converted it to a date field in your formula {@H_ConvertResolvedtoDate}. I meant for you to use that in the chart.

-LB

 

[maolsen]

How do I print on change of month. I am not seeing that as an option.

 

[lbass]

Add the date formula to the "on change of" area and while it is highlighted, click on "order"--then you will see the option to print on change of month--assuming that your conversion resulted in a date or datetime datatype.

-LB

 

[maolsen]

I fixed it. My date conversion was working but my qualification on what I was trying to gather the information on was wrong.

Thanks