{"id":13308,"date":"2026-04-09T04:13:06","date_gmt":"2026-04-09T04:13:06","guid":{"rendered":"https:\/\/kb-california.ondatasuite.com\/?post_type=ht_kb&p=13308"},"modified":"2026-05-20T02:38:28","modified_gmt":"2026-05-20T02:38:28","slug":"ad-hoc-reports-data-visualization-tool","status":"publish","type":"ht_kb","link":"https:\/\/kb-california.ondatasuite.com\/index.php\/knowledge-base\/ad-hoc-reports-data-visualization-tool\/","title":{"rendered":"Ad Hoc Reports\u2019 Data Visualization Tool"},"content":{"rendered":"\n

How can you custom build a report and data visualizations from the data in your OnDataSuite?<\/strong><\/p>\n\n\n\n

After beginning in the Dashboard, choose the type of data that you want to analyze and navigate there.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Modify your report to personalize it and shape it to answer your questions.<\/strong><\/p>\n\n\n\n

Step <\/strong>5
Choose All Students to view by category, or filter to a Focus List.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n


Step <\/strong>6
In Report Controls, turn on Graphing and Options to make adjustments.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Step 7
Click on the widget (graphing chart) that you want to adjust.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Step 8
Make changes in the structure of the charts and graphs.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Step 9
Such as: What criteria to use for Rows (y-axis),\u2026<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Step 10
and what criteria to use for Years (x-axis),\u2026<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Step 11
swap out the x and y axes by selecting inverse on the Widget Variant,\u2026<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Step 12
And\/or change the type of chart in the Widget Type.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Step 13
Make changes in the details of the charts and graphs. Such as theme, color, \u2026<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n


Step 14
description of the data that shows in the tooltip, \u2026<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Step 15
and the title of your chart.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Additionally, you can you can convert the data table from Step 4, into a heatmap. This can assist you with identifying patterns of extreme highs and lows using a gradient color scale.<\/p>\n\n\n\n

Step 16
Turn on Heatmap.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Step 17
Adjust the details of the heatmap by…<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Step 18
changing the color gradient focus; Ex. across rows (criteria chosen in Step 9), …<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Step 19
or by adding back in the zeros (criteria are omitted by default if they equal 0)<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Step 20
Turn on the charts (graphs), and the heatmap for a full picture.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

**ProTIP: Save it as a Custom Report to keep it for the future!<\/strong><\/p>\n\n\n\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

How can you custom build a report and data visualizations from the data in your OnDataSuite? After beginning in the Dashboard, choose the type of data that you want to analyze and navigate there. Modify your report to personalize it and shape it to answer your questions. Step 5Choose All…<\/p>\n","protected":false},"author":7,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[264],"ht-kb-tag":[],"class_list":["post-13308","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-ods-basics"],"_links":{"self":[{"href":"https:\/\/kb-california.ondatasuite.com\/index.php\/wp-json\/wp\/v2\/ht-kb\/13308","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kb-california.ondatasuite.com\/index.php\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/kb-california.ondatasuite.com\/index.php\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/kb-california.ondatasuite.com\/index.php\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/kb-california.ondatasuite.com\/index.php\/wp-json\/wp\/v2\/comments?post=13308"}],"version-history":[{"count":6,"href":"https:\/\/kb-california.ondatasuite.com\/index.php\/wp-json\/wp\/v2\/ht-kb\/13308\/revisions"}],"predecessor-version":[{"id":13518,"href":"https:\/\/kb-california.ondatasuite.com\/index.php\/wp-json\/wp\/v2\/ht-kb\/13308\/revisions\/13518"}],"wp:attachment":[{"href":"https:\/\/kb-california.ondatasuite.com\/index.php\/wp-json\/wp\/v2\/media?parent=13308"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/kb-california.ondatasuite.com\/index.php\/wp-json\/wp\/v2\/ht-kb-category?post=13308"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/kb-california.ondatasuite.com\/index.php\/wp-json\/wp\/v2\/ht-kb-tag?post=13308"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}