{"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-04-09T11:44:33","modified_gmt":"2026-04-09T11:44:33","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?<\/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

Step 1<\/strong>
Example: Click Student > Student Enrollment (SENR) > Academic Year Selection and type of file<\/p>\n\n\n\n

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

Step 2<\/strong>
Choose criteria for column headers Ex. Grade Level Code<\/p>\n\n\n\n

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

Step <\/strong>3
After you Create the Report\u2026<\/p>\n\n\n\n

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

Step <\/strong>4
you get a table with the aggregated values of that criteria (for drill down).<\/p>\n\n\n\n

\"\"<\/figure>\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: Your OnDataSuite will save your last settings for future use; i.e.\u00a0at a future date, repeat Steps 1, 2, and 3 and your OnDataSuite will give you Step 20.<\/strong><\/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. Step 1Example: Click Student > Student Enrollment (SENR) > Academic Year Selection and type of file…<\/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":4,"href":"https:\/\/kb-california.ondatasuite.com\/index.php\/wp-json\/wp\/v2\/ht-kb\/13308\/revisions"}],"predecessor-version":[{"id":13356,"href":"https:\/\/kb-california.ondatasuite.com\/index.php\/wp-json\/wp\/v2\/ht-kb\/13308\/revisions\/13356"}],"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}]}}