</p><p></p><p>So its time for the release of Code Creative Episode 2! I had a lot of fantastic followup questions from <a title="How to Build Custom Charts and Reports" __default_attr="4202" __jive_macro_name="blogpost" class="jive_macro jive_macro_blogpost" data-orig-content="How to Build Custom Charts and Reports" data-renderedposition="383_647.9400634765625_281_16" href="/community?id=community_blog&sys_id=317d2269dbd0dbc01dcaf3231f961911">How to Build Custom Charts and Reports</a> but the one that kept jumping out was "How do I do a Pivot Table?" In fact, this was a common question even before I released Episode 1 and your wish is my command. Sadly, though, High Charts does not offer a Pivot Table in ServiceNow. But there are two strategies that I have used for making Pivot Tables that have worked very well for me. In Episode 2, I cover the first of these strategies which allows you to minimize customization while getting more out of ServiceNow's native Pivot Table report. This method is so simple but surprisingly powerful.</p><p></p><p>And stay tuned for Episode 3 in which I will dig a little deeper into my bag of tricks and demonstrate a fully custom Pivot Table using a UI Page. Don't miss it! Put your questions in the comments and get it answered on Code Creative!</p><p></p><p>Original Question: <a title="Custom Chart Scripts" __default_attr="777391" __jive_macro_name="message" class="jive_macro jive_macro_message" data-orig-content="Custom Chart Scripts" data-renderedposition="551_123.91999816894531_156_16" href="/community?id=community_question&sys_id=caac87e5db9cdbc01dcaf3231f961938">Custom Chart Scripts</a></p><p></p><p><strong>Background Script:</strong></p><p></p><pre __default_attr="javascript" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_14319384062614016" data-renderedposition="633_8_1179_160" jivemacro_uid="_14319384062614016"><p>var gr = new GlideRecord('incident');</p><p>gr.query();</p><p>while (gr.next()) {</p><p> gr.autoSysFields(false);</p><p> gr.setWorkflow(false);</p><p> var updatedDt = gr.sys_updated_on.getGlideObject(); // Get GlideDateTime object</p><p> gr.u_updated_date = updatedDt.getDate();</p><p> gr.u_updated_hour = (updatedDt + '').substr(11, 2) + ':00';</p><p> gr.update();</p><p>}</p></pre><p></p><p><strong>Business Rule:</strong></p><p></p><pre __default_attr="javascript" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_1431938456338595" data-renderedposition="856_8_1179_96" jivemacro_uid="_1431938456338595"><p>function onBefore(current, previous) {</p><p> //This function will be automatically called when this rule is processed.</p><p> var updatedDt = current.sys_updated_on.getGlideObject(); // Get GlideDateTime object</p><p> current.u_updated_date = updatedDt.getDate();</p><p> current.u_updated_hour = (updatedDt + '').substr(11, 2) + ':00';</p><p>}</p></pre>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
