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

Whimzyy · July 2020

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 · July 2020

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 · July 2020

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 · July 2020

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

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

Best Answer

Answers

Categories