Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Is it possible to reorder multiple data sets? Move one to the front or back?

Alex Koziski
Kilo Contributor

Currently, I have to plan ahead to ensure the data I want in the front is put in FIRST, and each new dataset does behind the previous one.

Is there a way to reorganize this without removing and re-adding datasets?

1 ACCEPTED SOLUTION

Yea it doesn't seem there is a way as of now.


***Mark Correct or Helpful if it helps.***

View solution in original post

10 REPLIES 10

Yea it doesn't seem there is a way as of now.


***Mark Correct or Helpful if it helps.***

If the ability to reorder is key in the future, with Explore Analytics you can determine which of multiple data sets are in the foreground as a line or the background as bar with a left-click. Viewers can also hide data sets from view if desired.

find_real_file.png

MikeB3
Tera Contributor

If you have access to the report layers table (sys_report_layer) you can try changing its sequence.

Filter it for your report and then change the sequence value on each dataset. 

find_real_file.png

Hope this helps

Thanks @MikeB3 

 

For anyone curious, adjusting the sequence (higher the number, further into the background a dataset goes and vice versa) fixed this issue. 

MARCIA5
Tera Contributor

Among a lot of reports, I could find how to order my datasets with this tip. Thank you so much. I belive that this is the answer that  Alex Koziski  was looking for.