Hi I'm currently developing a whole suite of dashboards for my workplace and have hit an issue I cant work out and have searched every where for answers and have found none.

I'm developing within the coldfusion environment and my grid loads and populates fine but the grouping that I have enabled is not working and I think it maybe my JSON data format but cant be sure.

My JSON format looks like this:

{“ROWS”:“Account Enquiry”,”Adding a myki”,77.0,105.0,-0.27,385.0,601.0,-0.36],[“Account Enquiry”,”Archive cards”,0.0,64.0,0.00,451.0,17.0,25.53],[“Account Enquiry”,”Cancelling an account”,27.0,52.0,-0.48,164.0,165.0,-0.01],[“Account Enquiry”,”Change of details”,305.0,483.0,-0.37,2400.0,2311.0,0.04],[“Account Enquiry”,”Consolidate cards”,0.0,84.0,0.00,685.0,45.0,14.22],[“Account Enquiry”,”Obtain Balance”,560.0,1272.0,-0.56,6828.0,3604.0,0.89],[“Account Enquiry”,”Removing a myki”,16.0,28.0,-0.43,87.0,112.0,-0.22],[“Account Enquiry”,”Retrieve cards”,0.0,13.0,0.00,56.0,1.0,55.00],[“Account Enquiry”,”Tax invoice request”,11.0,33.0,-0.67,103.0,42.0,1.45],[“Account Enquiry”,”Transaction history”,502.0,1035.0,-0.51,5370.0,3334.0,0.61,”PAGE”:1.0,”RECORDS”:10,”TOTAL”:1.0}

Using the following CFC.