7 Replies Latest reply: Apr 13, 2012 1:46 PM by Kaushik Solanki RSS

Day Month Dimension

Alex Peasley

I would like to have both years show up on the same line/bar graph.

 

Date(Date,'MM/DD') - Right now I get two entries for 01/01, with 2 years of data. That makes sense, but I want to compare the two years, and I would like them be combined.

 

Any ideas?

 

Thanks,

Alex

  • Re: Day Month Dimension
    Carlos Lisboa

    Hi Alex,

     

    You could do it in multiple ways, i'll give you one which i believe is best.

    create two variables:

    vYearCurrent

    =max(Year)

     

    vYearPrevious

    =(

              if(

                        GetPossibleCount(Year)=2,

                        min(Year),

                        max(Year-1)

              )

    )

     

    and now you can use these variables in the set analysis with two expressions, one for each year. Something like:

     

     

    Current Year

    sum({< Year= {"$(=vYearCurrent)"}>} Value)

     

    Previous Year

    Current Year

    sum({< Year= {"$(=vYearPrevious)"}>} Value)

     

     

    The vYearPrevious is done that way so that when the user want to analyse non-contigous years the graph will remain usefull. If you want it simpler, this variable can be just =max(Year-1).

     

    Hope it helps

     

    Regards,

    Carlos

  • Day Month Dimension
    Oleg Troyansky

    I think the solution is very simple:

     

    Line chart with 2 dimensions: Year and Month.

     

    Months will supply the 12 values for the X-axes, and Year will cause multiple line series toe be created.

     

    If you have more than 2 Years of data, and you need to limit the scope for the chart, you can also add a Set Analysis condition in your expression to only count last 2 years.

     

     

    cheers,

     

    Oleg