Set analysis... or something else?

[clausbarlose]

I am bugged by the question of how to do this the easiest way, and I ask the community for help.

The data record is very simple:

Tickets:

TicketID (Key)	I-154356
Created	2014-12-31
Title	Thrusters defect

Dataset consists of a number of rows with ticket details, each with a different creation date.

Current selection is e.g. December 2014 and I want to show number of tickets created rolling month, twelve months back in time in a graph with year/month as the dimension.

Will it be necessary to create another table to do it or can it be done with set analysis?

Kind regards

Claus

[maxgro]

try with

dimension          =Year(Created) & '-' & num(Month(Created),'00')

expression        =count({$ <Created={">=$(=monthstart(addmonths(today(),-12)))<=$(=today())"}>} TicketID)

set full accumulation for expression and set the sort order

[clausbarlose]

Thanks, Massimo. Forgot to tell though, that twelve months rolling is not calculated from today() but Created.

I will have to try your formula out before I can tell if it works.

Thank you!

Kind regards,

Claus