Problem in a multiline graphic

[RicardoPereira]

It is possible create a graphic with the difference between months of different years for a specific measure.

Like this:

Nº Of orders

70 |
60 | .
50 | .
40 | .
30 | * *
20 | *
10 |
|____________________________________
January February March ....


*- Nº of orders 2002
.- Nº of orders 2003


Thanks
Ricardo

 

[drlex]

Yes, by using two dimensions. I have a similar plot in a sales model, using a month dimension in conjunction with the main date dimension (year level). The month dimension can be created by adding a calculated column in transformer which is month(order_date).
HTH
lex