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

Whimzyy

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! 

MarkSnodgrass

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.

MarkSnodgrass

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.

jaeW_at_Onyx

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