Bi-Annual graphs
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
2018-H1
2018-H2
2019-H1
And so which you will be able to use as an x-axis
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
This discussion has been closed.
Categories
- 7.4K All Categories
- 13 Getting Started in the Community
- 151 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 54 Domo Everywhere
- 2K Charting
- 1K Ideas Exchange
- 905 Connectors
- 239 Workbench
- 343 APIs
- 77 Apps
- 19 Governance & Productivity
- 237 Use Cases & Best Practices
- 50 News
- 473 Onboarding
- 573 日本支部