Assign date range field on a per column basis

I have a single table that some columns or calculations use one date field and other columns use another date field.

However domo only allows you to associate a single date field to the entire chart/table. This is extremely frustrating.

For example the red columns use TransactionDate but the green columns use InvoicePostedDate

My workaround is I lose the ability for a user to use the date filters altogether. I have to hardcode my date ranges (YTD, MTD, PriorYear, PriorMonth, etc) in beast mode and that is extremely time consuming and limiting as it doesn't allow the user to put custom date ranges.