Hello All,
Ive been trying a few things in other threads, but just cant seem to get this working. I have specific conditions that need to be counted per month.[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]ID[/TD]
[TD]Reason[/TD]
[TD]Timing[/TD]
[TD]Date[/TD]
[/TR]
[TR]
[TD][TABLE="width: 177"]
<tbody>[TR]
[TD="width: 177"]CRQ145074[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 183"]
<tbody>[TR]
[TD="width: 183"]Successful[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 137"]
<tbody>[TR]
[TD="width: 137"]Standard[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 149"]
<tbody>[TR]
[TD="class: xl65, width: 149, align: right"]9/1/2017 17:00[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 177"]
<tbody>[TR]
[TD="width: 177"]CRQ141919[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 183"]
<tbody>[TR]
[TD="width: 183"]Successful with Issues[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 137"]
<tbody>[TR]
[TD="width: 137"]Emergency[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 149"]
<tbody>[TR]
[TD="class: xl65, width: 149, align: right"]6/4/2017 11:15[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 177"]
<tbody>[TR]
[TD="width: 177"]CRQ153749[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 183"]
<tbody>[TR]
[TD="width: 183"]Backed Out[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 137"]
<tbody>[TR]
[TD="width: 137"]Normal[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 149"]
<tbody>[TR]
[TD="class: xl65, width: 149, align: right"]6/8/2017 13:20[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 177"]
<tbody>[TR]
[TD="width: 177"]CRQ161487[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 183"]
<tbody>[TR]
[TD="width: 183"]Successful[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 137"]
<tbody>[TR]
[TD="width: 137"]Standard[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 149"]
<tbody>[TR]
[TD="class: xl65, width: 149, align: right"]7/12/2017 8:21[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
I would like to have a count of the reason column broken down by date.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Jan[/TD]
[TD]Feb[/TD]
[TD]Mar[/TD]
[TD]Apr[/TD]
[/TR]
[TR]
[TD]Successful[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Successful with Issues[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Thanks
Ive been trying a few things in other threads, but just cant seem to get this working. I have specific conditions that need to be counted per month.[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]ID[/TD]
[TD]Reason[/TD]
[TD]Timing[/TD]
[TD]Date[/TD]
[/TR]
[TR]
[TD][TABLE="width: 177"]
<tbody>[TR]
[TD="width: 177"]CRQ145074[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 183"]
<tbody>[TR]
[TD="width: 183"]Successful[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 137"]
<tbody>[TR]
[TD="width: 137"]Standard[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 149"]
<tbody>[TR]
[TD="class: xl65, width: 149, align: right"]9/1/2017 17:00[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 177"]
<tbody>[TR]
[TD="width: 177"]CRQ141919[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 183"]
<tbody>[TR]
[TD="width: 183"]Successful with Issues[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 137"]
<tbody>[TR]
[TD="width: 137"]Emergency[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 149"]
<tbody>[TR]
[TD="class: xl65, width: 149, align: right"]6/4/2017 11:15[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 177"]
<tbody>[TR]
[TD="width: 177"]CRQ153749[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 183"]
<tbody>[TR]
[TD="width: 183"]Backed Out[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 137"]
<tbody>[TR]
[TD="width: 137"]Normal[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 149"]
<tbody>[TR]
[TD="class: xl65, width: 149, align: right"]6/8/2017 13:20[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 177"]
<tbody>[TR]
[TD="width: 177"]CRQ161487[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 183"]
<tbody>[TR]
[TD="width: 183"]Successful[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 137"]
<tbody>[TR]
[TD="width: 137"]Standard[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 149"]
<tbody>[TR]
[TD="class: xl65, width: 149, align: right"]7/12/2017 8:21[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
I would like to have a count of the reason column broken down by date.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Jan[/TD]
[TD]Feb[/TD]
[TD]Mar[/TD]
[TD]Apr[/TD]
[/TR]
[TR]
[TD]Successful[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Successful with Issues[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Thanks