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
 10.6K All Categories
 1 APAC User Group
 12 Welcome
 36 Domo News
 9.6K Using Domo
 1.9K Dataflows
 2.4K Card Building
 2.2K Ideas Exchange
 1.2K Connectors
 339 Workbench
 252 Domo Best Practices
 11 Domo Certification
 461 Domo Developer
 47 Domo Everywhere
 100 Apps
 703 New to Domo
 84 Dojo
 Domopalooza
 1.1K 日本支部
 4 道場日本支部へようこそ
 22 お知らせ
 63 Kowaza
 296 仲間に相談
 649 ひらめき共有