BiAnnual graphs
I have several graphs that I would like to graph by 6months/biannually. 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

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
2018H1
2018H2
2019H1
And so which you will be able to use as an xaxis
0
Answers

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
0 
Do you have an example of this?
0 
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
0
Categories
 11.4K All Categories
 6 Private Company Board
 2 APAC User Group
 12 Welcome
 45 Domo News
 10.3K Using Domo
 2K Dataflows
 2.6K Card Building
 2.3K Ideas Exchange
 1.3K Connectors
 356 Workbench
 272 Domo Best Practices
 14 Domo Certification
 484 Domo Developer
 58 Domo Everywhere
 114 Apps
 736 New to Domo
 86 Dojo
 Domopalooza
 1.1K 日本支部
 4 道場日本支部へようこそ
 32 お知らせ
 65 Kowaza
 305 仲間に相談
 668 ひらめき共有