I have to calculate the total # of cases created per day. Of those cases, how many were closed, who closed them and also how many of the original cases were still open at the end of the day. I want a daily look, weekly look, and monthly look.
In this scenario, you need to have a full calendar table (connecting your Case table on date column) with all different date parts columns (Year, Quarter, Month, Day and Week) so that data can aggregate on corresponding level. You also need a column for tagging a case is closed or not. Then you just need to create a measure to calculate daily created cases.