Bi-Annual graphs

Reply
White Belt

Bi-Annual graphs

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.  


Accepted Solutions
Purple Belt

Re: Bi-Annual graphs

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


All Replies
Purple Belt

Re: Bi-Annual graphs

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

 

White Belt

Re: Bi-Annual graphs

Do you have an example of this?

Brown Belt

Re: Bi-Annual graphs

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

Purple Belt

Re: Bi-Annual graphs

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

Announcements
Check out these great solution videos! The new iSolveditWithDomoboard is live, share yours and earn higher rankings in Dojo click here!