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? 



Best Answer

  • MarkSnodgrass
    Answer ✓

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

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

    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.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.


  • 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 ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
This discussion has been closed.