Graph by 1st-15th / 16th-EOM

Reply
Highlighted
Yellow Belt

Graph by 1st-15th / 16th-EOM

Hey everyone! 

 

I am using DOMO to run commission reports and I am curious if there is a way to graph by 1st-15th and then 16th to the end of month? I know I can Graph by Day, Week, Month and so on but is it possible to do biweekly? 

 

Thanks! 


Accepted Solutions
Highlighted
Black Belt

You could create a beast mode field that would group them into bi-weekly groups. You could do something like the following:

CONCAT(MONTHNAME(`Date`), 
(CASE WHEN DAY(`Date`) <= 15 
 	THEN '1st - 15th'
	ELSE '16th - EOM'
 END)
)

This would give you results, such as July 1st-15th, July 16th-EOM, etc... 

You would then just drag this into your x-axis and your date into the sorting to get them to display properly.




**Make sure to like any users posts that helped you and accept the ones who solved your issue.**

View solution in original post


All Replies
Highlighted
Black Belt

You could create a beast mode field that would group them into bi-weekly groups. You could do something like the following:

CONCAT(MONTHNAME(`Date`), 
(CASE WHEN DAY(`Date`) <= 15 
 	THEN '1st - 15th'
	ELSE '16th - EOM'
 END)
)

This would give you results, such as July 1st-15th, July 16th-EOM, etc... 

You would then just drag this into your x-axis and your date into the sorting to get them to display properly.




**Make sure to like any users posts that helped you and accept the ones who solved your issue.**

View solution in original post

Highlighted
Major Red Belt

Just make sure to include year with @MarkSnodgrass  solution.

 

To make a sort-able column I'd recommend generating an integer 

 

Year() * 100 + Month() * 10 + CASE WHEN ... then 1 else 2 END

 

GOAL: 2020011 or 2020012


Jae Wilson
Check out my Domo Training YouTube Channel

**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"
Announcements
Stand out in the Dojo: Choose your own recognizable username and add a unique profile photo in your profile settings.