Running total with blank month

[yazenbarakat123]

I have an incident table that has a date field , the issue I am facing is there can be insitances where there is no incidents for the month resulting in blank dates so I created a calendar table and setup a one to many relatioship to my incident table on the Date>IncidentDate fields.

My reqriment is to create a running total for the incidents on a month to month basis and if there is a blank month return the previous months incident total 


for some reason I cant accomplish this without A skipping over May resulting in a break in my line visual or a continous past the current month causing confusion as why we have incidents in months that didnt happen yet 

 

 

 

 

Any help would be appreciated!

[Anonymous]

Hi @yazenbarakat123 ,

Thanks for the reply from @some_bih .

Was the method some_bih provided helpful? Did it help you solve the problem?

If yes, please accept his answer as the solution, which will be of great help to users who encounter similar problems as yours.

If you have any further questions, please feel free to contact me.

Best Regards,
Yang
Community Support Team

[some_bih]

Hi @yazenbarakat123 use dates, like month column, from your Calendar / Date table.