1 Reply Latest reply: Oct 11, 2016 6:33 PM by Stefan Wühl RSS

    year vs year comparisson issue bar/line chart

    Marius August Larsen

      Hi,

      I have an issue with this bar selected year vs prevous year.

       

      Month, Time, Week is okey, but when i select date as dimension the chart transfer to this:

       

      Expression:      Sum({<År= {$(= max(År))}>}kWhVG)

                              Sum({<År= {$(= max(År-1))}>}kWhVG)

       

       

      Month; Works

       

      Clock; Works

        • Re: year vs year comparisson issue bar/line chart
          Stefan Wühl

          One expression filters the record set to the records related to max year and the other expression to records related to max year -1, right? So if you draw your expressions against a date dimension, that's the expected result, I think.

           

          Maybe use DayNumberOfYear(DateField) or something similar as dimension instead of DateField. Any dimension with dimension values that are related to both years for every dimension value.