Gauge and Bar Chart for next 6 months or current month

[cbaqir]

I am trying to accomplish 3 things using set analysis and FABS but having issues using Date(AddMonths(monthstart(today()),6))) and FABS:

1. Create a gauge chart for the next 6 months
   1. 1-(sum(FABS([Assigned Hours]))/sum([Available Hours]))
2. create a gauge chart for the current month
   1. 1-(sum(FABS([Assigned Hours]))/sum([Available Hours]))
3. create a stacked bar chart for the next 6 months 
   1. Available hours: sum({<[CHKBK_MONTH]={">=$(= Date(AddMonths(monthstart(today()),6)))>=$(=monthstart(today()))"}>} [Available Hours])
   2. Assigned Hours: sum({<[CHKBK_MONTH]={">=$(= Date(AddMonths(monthstart(today()),6)))>=$(=monthstart(today()))"}>} FABS([Assigned Hours]))

[sunny_talwar · Accepted solution]

Check attached

[cbaqir]

Thanks Sunny!