Dynamic Month over Previous Month

[Wayne McCLure]

I have a bar chart currently showing current ticket creation [number] for the month and another axis is the month previous. I pull the date from the ticket create date column [sys_created_on]

I want an additional refinement to show month previous up to the day. As example: Today is the first, current ticket creation is 475; while the month previous is over 35k. This doesn't show month with enough granularity to be super useful. I'd like to see previous month sum to the current date.

 

Currently I have a two calculated colums:

Concatenate(Year([sys_created_on]),Month([sys_created_on]))

UniqueCount([number]) over (Previous([yearmonth]))