Reports and Custom Charts

[bhenson]

Good morning all,

Still learning ServiceNow and making my first foray into Custom Charts.   I have 2 reports that separately display the data I want to combine into 1 custom chart.   Is there any way to use those 2 reports as my Data Generators or find the code that renders those reports to copy into my Data Generators when I create them?

Struggling with getting the code right to generate the data and hoping for a way to leverage what I have already created in SN to create something new and wonderful.   🙂

Thanks in advance for your assistance.

[Chris M3]

So, in your summary sets, rather than setting your summary line for the grouping to the actual date, set it to the Month-Day string.   This way the data is the same between the two summary sets.

[bhenson]

Thanks Chris.   Now if I can just figure out how to do that....

I am OBVIOUSLY not as accomplished with this scripting stuff as you!  

[bhenson]

Got it - at least as a bar chart.   Now if only I can figure out how to use renderers to create a line chart since the getChart(Dataset) method is broken for lines in Berlin.

Thanks for all your help Chris!!

[Harish Murikina]

Hi bhenson,

                            Good Morning !!.

                Could you confirm one thing. Once you click on the report is it redirecting to data?

                If yes could you please help me in my case its not happening.

Regards,

Harish Muriknati.

[bhenson]

Harish,

There is no drill-down capabilities in my chart - it displays the graph only.   Clicking on the graph does not direct you to data display.

Belinda