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

Whimzyy
Whimzyy
in Card Building

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! 

Best Answer

  • MarkSnodgrass
    MarkSnodgrass Portland, Oregon 🟤
    Accepted Answer

    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.

Answers

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🟤

    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

This discussion has been closed.

Categories