Welcome to Community Week 2025! Join us to learn, connect, and be recognized as we celebrate the spirit of Community and the power of AI. Get the details  

Multiple Dataset Report, how to eliminate or rename the label of the first data point?

christopherlohm
Kilo Explorer

In creating a standard report, using the "Multiple Dataset" feature offered by PA Premium, I find that the original dataset inherits the name of the table that it is created against.   Any ideas on how to change that?   My first dataset is named "Incident" or "Task" while the additional datasets all have elegant series names.   I need to either rename the initial dataset or eliminate it entirely and work only within the multiple dataset UI; can't figure out how to do either.

1 ACCEPTED SOLUTION

RJ Barmentloo
ServiceNow Employee
ServiceNow Employee

Hi all,



as from the Kingston release you will be able to name the first dataset in a multiple dataset report. Just go back to the first data set configuration and rename it there. See attachment for clarity.



Hope that helps!


Best regards,



-Robert


Screen_Shot_2018-01-22_at_10_15_04_AM.png


View solution in original post

4 REPLIES 4

christopherlohm
Kilo Explorer

One method that I have found is to simply setup a bad filter for the base dataset.   If it returns no tickets then it seems to exclude it from the chart.   That seems a little hacky.   Anyone know of a more elegant way?


@christopherlohman@fico.com



How did you get it working with a bad filter ? I tried within a trend report, but it still shows "0"-line. Even choosing "white"-color does not work in that case and line gets default blue...



Update: i now got it working with a count aggregation and using white color line. It also still shows table label name in legend but with no function if you click on it. I would not call this a "real" workaround but better than nothing.



Thx and best regards


Vesp


RJ Barmentloo
ServiceNow Employee
ServiceNow Employee

Hi all,



as from the Kingston release you will be able to name the first dataset in a multiple dataset report. Just go back to the first data set configuration and rename it there. See attachment for clarity.



Hope that helps!


Best regards,



-Robert


Screen_Shot_2018-01-22_at_10_15_04_AM.png


Hello Robert, thats a good news! Maybe going the "workaround" way in non-Kingston instances is a better alternative than renaming whole table label until instance is upgraded to Kingston.



Thx for checking in newest version


Vesp