nick9one1 Report post Posted December 7, 2012 (edited) Hi, New to collabion charts and just trying to get used to the product with some simple charts. Although I seem to have a problem with grouping? I've basically connected to our SQL asset tracking DB and selected the columns that show PC manufacturers, and locations of the PC's. My current setup is attached; Edited December 7, 2012 by nick9one1 Share this post Link to post Share on other sites
nick9one1 Report post Posted December 7, 2012 (edited) When I try to group the data im having problems... My goal is to group the data by location, and show total of each type of manufacturer in those locations. I get the following error... Edited December 7, 2012 by nick9one1 Share this post Link to post Share on other sites
Rahul Kumar Report post Posted December 7, 2012 Hi Nick, Grouping can't be applied on column which has blank/empty fields, so could you please check if there are such fields in the data? Share this post Link to post Share on other sites
nick9one1 Report post Posted December 10, 2012 (edited) Thanks for the response. Yes, there are blank fields. Can I remove thse with the 'filter data' option? Edited December 10, 2012 by nick9one1 Share this post Link to post Share on other sites
Rahul Kumar Report post Posted December 11, 2012 Hi, I am afraid, it is not possible to remove the blank fields using the Wizard. Since you are using SQL so you can change your existing query in such a way that it will not result any empty fields for LOCATION_ID column. Share this post Link to post Share on other sites
DawnCortez Report post Posted September 8, 2015 How to remove the blank fields? Professional resume writing service will make your resume as the best since it is the first item for a potential job seeker.Resume is a written compilation of your education, work experience, credentials, and accomplishments that is used to apply for jobs. It is one of the most important pieces of any job application Share this post Link to post Share on other sites
