Comments
-
The Graph By wouldn't work in this case because I am trying to isolate the beastmode. There are other beastmodes that are all indicating different time brackets on that page.
-
@amehdad My card is a pivot table so it's not about the bar size. I am looking to just drag the columns smaller or wider so that some of the fields can be read.
-
The Dataset format is like this, but the dates aren't limited to 2021 obviously.
-
Sorry I'm still not getting it. Not sure how to use a pivot table to get the ranks by month and total.
-
Rank() Over(partition by MONTH(`EventDt`),YEAR(`EventDt`) order by COUNT(`Certificate#`)DESC ) turns out like this
-
oh that worked thank you so much!
-
Could you explain how that works? Not sure what you mean.