How do I hide a recordthat is not part of my filter set?

Question

Hi

I am trying to get to grips with the new report tools. I only do one set of reports and year and a lot has changed!  I have a report that I have added a filter for a specific department and as you can se form the attached I have a number of records that are pulling through as blank but with the name of the person.

These people are not in the filtered department so I don't want to see them. I have added them as a breakout because I need their name next to there comments. In the old version I would have added them as a column and then sorted the column order to put the name before the comments.

When I created a report instead of using the reports tool, the filters worked and I could change the column order. How do I do that with the results tool?

Any help wold be greatly appreciated.

LaurenK · Accepted Answer

Hey @Graham_at_SHU! It looks like you reached out to our Support team regarding this inquiry! Our specialist recommended changing the Data Source to what you wanted to appear in the first column. Below the Data Source, the Additional Columns section was used to add the comments to your visualization! If other community members are looking for more information, check out the FAQs found on this page!

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded