I have a table containing a Date-and-Time field. I wish to create a chart with a date range that shows rows per day, week, or month.
I have two issues that seemingly make this an impossible problem to solve without restructuring my table, which seems like it should not be a requirement.
I can’t target a date or date range, instead each date is unique due to it being a date-time.
I am unable to count rows, I can only count values within the row, which is not desired. This means counting the total amount of money of all orders is easy, but counting the amount of orders is much more difficult.
Does anyone have a solution for these problems? Am I missing something, or is there an intended method to solve these sorts of problems?