I figured it out. The solution I ended up going with was having the amount for the quarter as its own row, and all the other rows for the quarter be filled with '0'. Ifnull(`Amount`,0) worked just fine to fill in null values.
It could be sorted by highest corresponding value. For example, if Friday is worth 6 and Monday is worth 4, Friday will be listed first. If that's either irrelevant or there's a different criteriato follow it may default ot that. For example I have a quick filter based on a beast mode calculation that takes…