Bi-Annual graphs

user04045
user04045 Member
in Charting

I have several graphs that I would like to graph by 6-months/bi-annually.  Since this is not a standard option in the Graph By drop down box, I am not sure how to go about doing this.  

Best Answer

  • rado98
    rado98 Contributor
    Answer ✓

    Hi

     

    Building up on DanB's logic, you can probalby need the following too

     

    Concat( Year(DateField),'-',

    Case when MONTH(DateField) <= 6 then 'H1' when MONTH(DateField) > 6 then 'H2' end

    )

     

    Thsi way you woudl get

    2018-H1

    2018-H2

    2019-H1

    And so which you will be able to use as an x-axis

Answers

  • rado98
    rado98 Contributor

    Either create a beastmode that groups dates in yearly halves or create a data set with the grouping and joint to your existing data set.

    Then use the grouping in the charts

     

  • user04045
    user04045 Member

    Do you have an example of this?

  • Unknown
    Unknown

    In a Beast Mode calculation, it would be something like:

    Case when MONTH(DateField) <= 6 then 'First Half' when MONTH(DateField) > 6 then 'Second Half' end

  • rado98
    rado98 Contributor
    Answer ✓

    Hi

     

    Building up on DanB's logic, you can probalby need the following too

     

    Concat( Year(DateField),'-',

    Case when MONTH(DateField) <= 6 then 'H1' when MONTH(DateField) > 6 then 'H2' end

    )

     

    Thsi way you woudl get

    2018-H1

    2018-H2

    2019-H1

    And so which you will be able to use as an x-axis

This discussion has been closed.

Categories