my formula would look like below:
No, forget RunStatus. That should be ActiveCount. I just included runstatus because I didn't want to reorder all the columns to show in a single jpeg. That is just a "Placeholder". Yes active count is a whole number.
OMG that worked!! Dude you saved my life haha. Was about to punch my monitor. I was using my calendar table the whole time, which may have been the issue??
Here is the actual formula with proper column names. Why would my date table not work? Typically instead of
I noticed that as well, but it is because I organize by MonthNum. If I don't do that the numbers are messed up on a line graph. I don't think that is the issue? The order of the column itself should not matter if all the dates are there and they are organized accordingly? That is just how the data is stored?
You know what... maybe that is causing an issue. How do I fix that? It is a sorting issue I presume, but not sure how to fix. Again, I had to organize a lot of cells by monthnum otherwise they would be out of order
It depends on how your date table is built but what is happening in the measure it is filtering the date table for every date that = say 1/2/2019 and it is not finding a line for 1/2/2019 in your date column so it is returning a blank.
Your date column should have every date for the whole spacn so 365 rows a year. For sorting months, you can always set the sort coumn of month name to be month number so it appears Jan, Feb, Mar in charts.