Chronological Order

[#1]

I have two fields, one is called Departure Month and the other is Departure Year

Departure Month is listed as a number so January = 1

Departure year is also number so 2017-2017

I want to combine the two into a single dimension so that my dimension is in chronological order.

[swuehl]

Maybe use something in script or chart dimension like

Monthname(Makedate([Departure Year],[Departure Month]))

[Anonymous]

In the data load editor you can say

Load

      Departure Year & '-' & Departure Month as Fieldname

the result should be Month-Year

[eliran]

Hi,

I prefer a different approach, I usually create a date field, makedate(departure year, departure month, 1),and then play with formatting.

But it really depends on the use case, once you got a date, it's easier to calculate gaps between two periods, use set analysis, etc.

On the other hand, sometimes you need / want to keep it simple.

Hope it helps,

Eliran.