<style>p { margin: 0; }span.fr-emoticon.fr-emoticon-img { background-repeat: no-repeat !important; font-size: inherit; height: 1em; width: 1em; min-height: 20px; min-width: 20px; display: inline-block; margin: -0.1em 0.1em 0.1em; line-height: 1; vertical-align: middle; } span.fr-emoticon { font-weight: normal; font-family: "Apple Color Emoji", "Segoe UI Emoji", "NotoColorEmoji", "Segoe UI Symbol", "Android Emoji", "EmojiSymbols"; display: inline; line-height: 0; } blockquote { border-left: solid 2px #5e35b1; color: #5e35b1; margin-left:0; padding-left:5px;}blockquote blockquote{ border-color: #00bcd4; color: #00bcd4;}blockquote blockquote blockquote{ border-color: #43a047; color: #43a047;} table.grid{ border-collapse: collapse;} table.grid td, table.grid th { border: 1px solid #ddd;} .fr-fic.fr-dib{ display: block; margin: 5px auto;}.fr-fic.fr-dib.fr-fir{ text-align: right; margin: 5px 0 5px auto;}.fr-fic.fr-dib.fr-fil{ text-align: left; margin: 5px auto 5px 0;}.fr-fic.fr-dii{ float: none; margin: 5px auto;}.fr-fic.fr-dii.fr-fil{ float: left; margin: 5px auto;}.fr-fic.fr-dii.fr-fir{ float: right; margin: 5px auto;}img.fr-dib.fr-fir { margin-right: 0; text-align: right;}img.fr-dib.fr-fil { margin-left: 0; text-align: left;}img.fr-dib { margin: 5px auto; display: block; float: none;}img.fr-bordered { box-sizing: content-box; border: solid 5px #CCC;}img.fr-shadow { box-shadow: 10px 10px 5px 0px #cccccc;}img.fr-rounded { border-radius: 10px; -moz-border-radius: 10px; -webkit-border-radius: 10px; -moz-background-clip: padding; -webkit-background-clip: padding-box; background-clip: padding-box;}</style><p id="isPasted"><strong>In this guide we will cover:</strong></p><p><strong>- What is Ticket Forecasting?</strong></p><p><strong>- Ticket Volume History</strong></p><p><strong>- Configuring Forecasting</strong></p><p><strong>- Running Forecasts</strong></p><p><strong>- Reporting on Forecast Output</strong></p><p><strong>- Adding Forecasts to Existing Reports</strong></p><p><br></p><p><br></p><p><strong>Related Guides:</strong></p><ul><li style="font-weight: bold;"><a href="https://usehalo.com/haloitsm/guides/2584/" target="_blank" rel="noopener noreferrer"><strong>Nixtla TimeGPT Integration</strong></a></li></ul><p><br></p><p><br></p><p><strong><span style="font-size: 14pt;">What is Ticket Forecasting?</span></strong></p><p>Ticket Forecasting uses historic Ticket Volume data to allow predictions of future inbound Ticket Volumes.</p><p><br></p><p><strong><span style="font-size: 14pt;">Ticket Volume History</span></strong></p><p id="isPasted">This module allows you to configure tracking of inbound (tickets logged) data which is grouped on an hourly basis. You may configure specific Ticket Types and Sources to be logged to the "HistoricalTicketVolumes" table.</p><p><br></p><p>This will run a query every hour to count the number of Tickets logged for the configured Ticket Types and Sources, and record this as a row in the table. This is run for the previous hour, each hour when enabled. Dates are stored in UTC.</p><p><br></p><p>In Configuration > Reporting, enable the "Ticket Volumes" module by hovering over it, and click the "+" icon, which will then change to an "x".</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjgzMzQ1ZDM5LTg5ZDktNDJmMy1iMDk1LTc1ZDlkNDY2NWJmNSJ9.bQMzCCRWEiOq-mTXzVurom8zDn8XyTDlacn8CaJPcO4" class="fr-fic fr-fil fr-dib" width="203" height="151"></p><p><strong><span style="font-size: 10pt;">Fig 1. Enabled Ticket Volumes module.</span></strong></p><p><br></p><p>Clicking into the module will show the below screen. Here, you can set which Tickets will be tracked, and then "Enable Tracking".</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjE4Y2RkNjg4LTU5ODctNDhmYy1hYzVmLTAwMzVjNzQ0YWRiNyJ9.CgsnAC-kwmn5jm0hLH3MLhfSkQqRZwBOEifW_bCLjFQ" class="fr-fic fr-fil fr-dib" width="1219" style="width: 1221px; height: 429.043px;" height="429"></p><p><strong><span style="font-size: 10pt;">Fig 2. Ticket Volume configuration.</span></strong></p><p><br></p><p>Clicking the "Add" button on the table will allow you to add a Ticket Type and Source to track. Repeat this with each combination you want to track.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImE0OGQwMzdhLTY1NDQtNDI5OC1iZjg1LWM1MzU1NjM4ZTMwMiJ9.FzUXVilWcCNAnFDNu_PtL-imrBsBBUMnvtyQ6nvML2w" class="fr-fic fr-fil fr-dib" width="708" height="329"></p><p><strong><span style="font-size: 10pt;">Fig 3. Popup to add a Ticket Type and Ticket Source combination.</span></strong></p><p><br></p><p id="isPasted">Historical Ticket Volume data can also be imported via spreadsheet import, using the below format.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjRlNTVlZGVhLTU0OGItNDFhZS05MGRhLTRjMzIwZGY2ZjQzNyJ9.FOlTPWADeydBj7QQk7dwHAQG2WD42LzeMBHbEwdZj04" class="fr-fic fr-fil fr-dib" width="649" height="67"></p><p><strong><span style="font-size: 10pt;">Fig 4. Example spreadsheet.</span></strong></p><p><br></p><p>Once tracked/imported, the data will show on the "Historical Ticket Volume Data" tab.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjZhNjM4ZjRjLTc5YjAtNDJjZS05NjEzLTU5MWU2NTZiYzY5YiJ9.1qQ4L7V4AH327aDBBDJwQ-DnIGOxD3Fa8CAXk2oF-TA" class="fr-fic fr-fil fr-dib" width="1219" style="width: 1221px; height: 378.36px;" height="378"></p><p><strong><span style="font-size: 10pt;">Fig 5. Historical Ticket Volume Data tab.</span></strong></p><p><br></p><p><strong><span style="font-size: 14pt;">Configuring Forecasting</span></strong></p><p id="isPasted">This module will allow you to predict future values for a dataset over a given frequency and horizon. For example you could predict the next 7 days of inbound Tickets for each hour, or you could predict the next 12 months of inbound Tickets by each month.</p><p><br></p><p>If using the <a href="https://usehalo.com/haloitsm/guides/2584/" target="_blank" rel="noopener noreferrer"><strong>Nixtla TimeGPT</strong></a> integration, you may augment your historical data with "Events" (exogenous data). An Event is a period of time marked as something that would influence the inbound volume, for example a public holiday, or marketing drive. This can be marked against your historical data, and added for the future so the model can take the previous, historical data into account for an event which is going to happen in the horizon of the forecast. This should provide a more accurate forecast.</p><p><br></p><p>Forecasted data is output to the "ForecastOutputValue" table and can be used in reporting to visualise the predictions.</p><p><br></p><p>In Configuration, hover over the "Forecasting" module and click the "+" to enable it.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImUwZTBiYjFkLTJlNGEtNGY5Mi04NDc0LTNjNWRhMDhmZGMzMCJ9.PtPaUrnLhxHcAJV2sDmvIifqtk7cADH34olcwuIoxiE" width="199" height="145" class="fr-fic fr-dii"></p><p><strong><span style="font-size: 10pt;">Fig 6. Forecasting module.</span></strong></p><p><br></p><p>Clicking into the module will show a list of forecasts if existing. Click the "New" button to create one.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjgwN2E2ZDZjLWYxN2MtNDQ5MS05NTEyLTNjZmZmYWFkY2QxNiJ9.MLEpra_UYBk-8dsi_k6aEwO8DPxdTZDEAOaU8WIkRmA" width="1222" style="width: 1224px; height: 115.933px;" height="116" class="fr-fic fr-dii"></p><p><strong><span style="font-size: 10pt;">Fig 7. Forecast list.</span></strong></p><p><br></p><p>The below screen will then show to create a forecast. Give it a relevant name, and choose "Ticket Volumes". You can then choose to restrict the forecast to certain Ticket Types or Sources that have been mapped in the Ticket Volumes module.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImFjZDk5Mjc1LTBmNTktNDQ1YS05YTgwLWI1ZDZhNjkwODQzYyJ9.gxBbSCJ9E56Zw2vs-q2biHUrjT1bbR8YZyKDAjcWDsQ" class="fr-fic fr-fil fr-dib" width="1214" style="width: 1216px; height: 357.463px;" height="357"></p><p><strong><span style="font-size: 10pt;">Fig 8. Configuring a forecast.</span></strong></p><p><br></p><p>We can then select which "Model to use" to create the forecast.</p><p id="isPasted"><br></p><ul><li><strong>Moving Average:</strong> Uses the average of recent values to smooth and forecast.</li><li><strong>Linear Regression:</strong> Projects a straight-line trend forward from past data.</li><li><strong>Simple Exponential Smoothing:</strong> Forecasts with more weight on recent values to follow trends.</li><li><strong>timegpt-1/timegpt-1-long-horizon:</strong> Requires configuration of the <a href="https://usehalo.com/haloitsm/guides/2584/" target="_blank" rel="noopener noreferrer"><strong>Nixtla TimeGPT</strong></a> integration. Use timegpt-1-long-horizon for forecasting if you want to predict more than one seasonal period given the frequency of your data.</li></ul><p><br></p><p>Next, we can set the configuration of that model. This will differ slightly if using an integration method. In this example, we are using the "Moving Average" model.</p><p>You can also then choose whether to allow negative or decimal values.</p><p><br></p><p>Upper and lower bound limits can be set to ensure predictions are capped at realistic limits that reflect the scenario, i.e. sales values will never go below 0 or above a set ceiling per period.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImFiOGYyOTU2LWFkMmUtNDYwMi1iMGVjLTkxNWJmM2UxMDQxNyJ9.fIsgCh95wQUQSI40usfsxWmqBK0e_E96CD8iFoMn7sY" class="fr-fic fr-fil fr-dib" width="1070" style="width: 1072px; height: 436.849px;" height="437"></p><p><strong><span style="font-size: 10pt;">Fig 9. Model configuration.</span></strong></p><p><br></p><p id="isPasted"><strong><span style="font-size: 14pt;">Running Forecasts</span></strong></p><p>After configuring the model, save the forecast. Switch to the "Preview Forecast Input Data" tab to preview the values that will be used for the forecast.</p><p><br></p><p><img data-fr-image-pasted="true" src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImE1MWE4ZDg4LWQwYTctNDc3Mi1iZGI2LWI1OTM0ODY5ZTRhOCJ9.6gWzQxm0bbfIgARlRJ6xQUhKXnm-XkEBf4dzoj_2-R4" width="1215" height="325" style="box-sizing: inherit; border-style: none; cursor: pointer; padding: 0px 1px; user-select: none; text-align: left; color: rgb(0, 0, 0); font-family: sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; width: 1217px; height: 325.422px; max-width: none !important;" id="isPasted" class="fr-fil fr-dib"><strong><span style="font-size: 10pt;">Fig 10. Preview Forecast Input Data tab.</span></strong></p><p><br></p><p>You can then switch back to the "Details" tab and click the "Run Forecast" button that will show under the "Model configuration" section. At this point, the "Save Forecast Output" button will be greyed out.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImViOWI0MWY1LTZhMWItNDk0MC04MDNkLTg4M2VhYmZmMWMwZCJ9.2JpV_cHVLbAzEGS4ci5xKLHEKe2D7H8EpViDxevnMsE" class="fr-fic fr-fil fr-dib" width="475" height="157"></p><p><strong><span style="font-size: 10pt;">Fig 11. Run Forecast button.</span></strong></p><p><br></p><p>After running the forecast, you can switch to the "Forecast Output" tab to show the Forecast.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjkwMmViMjRmLWNjNmMtNDg5My04ZTYwLWE4YmViNGU5NGQ4NiJ9.Dcw--FYOsnOrKYrsnJ6yT5FRvvsBOgoBhVvvc0rrzbs" class="fr-fic fr-fil fr-dib" width="1218" style="width: 1220px; height: 330.433px;" height="330"></p><p><strong><span style="font-size: 10pt;">Fig 12. Forecast Output tab.</span></strong></p><p><br></p><p>Once you have confirmed the output, back on the "Details" tab you can set a schedule for the forecast to run to keep the data up-to-date. Here, click the "Set Schedule" button to set how often the forecast will run and update, i.e. once a month on the first day.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6Ijg2OTY0MzQwLTE2ODktNGIyOS1hMGY2LTA5MDhiZDk3MzBlZSJ9.FZ_Kdjh1AViNvG95SvvHIxyW_pPXHyQ5fiTXC9oWSNg" class="fr-fic fr-fil fr-dib" width="1217" style="width: 1219px; height: 612.331px;" height="612"></p><p><strong><span style="font-size: 10pt;">Fig 13. Adding a schedule.</span></strong></p><p><br></p><p><strong><span style="font-size: 14pt;">Reporting on Forecast Output<br></span></strong></p><p>On the "Details" tab, the "Save Forecast Output" button is now available.</p><p><br></p><p><img data-fr-image-pasted="true" src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImE0NGQ5N2YwLTliZmEtNGM2NC1iNTcyLTY2ZWVhMTRmYTUyNCJ9.9zCqkLKifuU0Dhyrd_aEzmV1hwoA6a4baHfFJC8VDtk" width="465" height="126" style="box-sizing: inherit; border-style: none; cursor: pointer; padding: 0px 1px; user-select: none; text-align: left; color: rgb(0, 0, 0); font-family: sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; max-width: none !important;" id="isPasted" class="fr-fil fr-dib"></p><p><strong><span style="font-size: 10pt;">Fig 14. Save Forecast Output button.</span></strong></p><p><br></p><p>Clicking this will show a popup to save the Forecast Output. The name of this will default to the name of the Forecast, alongside the period dates.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImNjYzY5ZDg2LTNkOTctNGQwNy1iNmJiLWE5MzVhOTlmZDY0YSJ9.BM0kSHQSCR-3dXn-fW0q9_2kx_iHWMxRxvgF-7QE8Cg" class="fr-fic fr-fil fr-dib" width="708" height="246"></p><p><strong><span style="font-size: 10pt;">Fig 15. Saving output.</span></strong></p><p><br></p><p>Once saved, the Forecast Output will now be available in the Reporting area > Saved Forecasts.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjRiY2MyMmVmLWFiNDQtNDE2NC1iNDBlLWRiMTBlZGRkODQ3NCJ9.MmhGLUOwAkbCW0lL46AMD_06gwU1PUDkSmkyNNdAVyw" class="fr-fic fr-fil fr-dib" width="1210" style="width: 1212px; height: 240.967px;" height="241"></p><p><strong><span style="font-size: 10pt;">Fig 16. Saved Forecasts area.</span></strong></p><p><br></p><p>Clicking into the Forecast Output will show information about the output, alongside the ID to use when reporting on this output. In this case, "FOVsfid = 1".</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjIwN2MxYTg3LWU0ZDktNDg2Yy05NDg3LTk2MjE2NGMwYzcwNSJ9.3rCSHTXBBqlx1BHVBqh58W8uu4G_klIn40xk1HyB-XQ" class="fr-fic fr-fil fr-dib" width="1212" style="width: 1214px; height: 429.931px;" height="430"></p><p><strong><span style="font-size: 10pt;">Fig 17. Forecast reporting information.</span></strong></p><p><br></p><p>Entering this example SQL into a report will show the following data.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjQ2MDllZWRiLWVlNGEtNGZkMC05Nzk1LTZjMTY5MGY5MzYwMiJ9.PXSAzci2U72Ce4XWRA4Ua2jLjOLZsC8Z_odJTI02XHg" class="fr-fic fr-fil fr-dib" width="1210" style="width: 1212px; height: 626.897px;" height="627"></p><p><strong><span style="font-size: 10pt;">Fig 18. Reporting data.</span></strong></p><p><br></p><p><span style="font-size: 14pt;"><strong>Adding Forecasts to Existing Reports </strong></span></p><p>Forecasts can be added directly to reports on both charts and the data table to show predicted values for the data shown. In Configuration > Reporting > General Settings, enable "Show the Forecasting tab on Reports".</p><p><br></p><p>Then in the Reporting Suite, edit a report, and navigate to the the "Forecasting" tab. Click the "Add Forecast" button.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImRlYjkxNjJjLTQ2NzMtNDI0OS1iMGE2LWViODI1NjNjYmZmNiJ9.CRlgbp9QDCSORfFCBy2HeuAeq4Q9CqLcZPaDmBbjdO0" class="fr-fic fr-fil fr-dib" width="1216" style="width: 1218px; height: 313.312px;" height="313"></p><p><strong><span style="font-size: 10pt;">Fig 19. Adding a forecast to a report.</span></strong></p><p><br></p><p>A popup will show to configure a forecast for this report. Choose a date field, an a value field to track. Configure the model options as before.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjczMDVkMThkLTI3YjctNGYzNS04NDEyLTMxOTg1Y2U2ZTM2OSJ9.0Ybxbc5JjKfwKOD6gWZF6nMVVH4X5qYplv60kHDg0nI" class="fr-fic fr-fil fr-dib" width="1220" style="width: 1222px; height: 581.597px;" height="582"></p><p><strong><span style="font-size: 10pt;">Fig 20. Configuring the forecast.</span></strong></p><p><br></p><p>After saving, click the "Run Forecast" button in the popup. Exit out of this popup after, where you can then configure whether the table and/or chart shows the predicted values from the forecast.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImNiMjk2NWQyLTliZGUtNGVmYS1hYmQ4LTdmOGIyMDVlYWU2MyJ9.aB3uYnPRB_bnOoy3PS09WqD7XFeSLoPNFpxEq0SWoWs" class="fr-fic fr-fil fr-dib" width="1214" style="width: 1216px; height: 310.053px;" height="310"></p><p><strong><span style="font-size: 10pt;">Fig 21. Enabling predicted values.</span></strong></p><p><br></p><p>You can now save and load the report. Next to the results, you can see the date and time the forecast was last ran. </p><p><br></p><p id="isPasted"><strong><em>Note: Forecasts will not run every time a Report runs. They automatically run once for each new period based on the Forecast frequency, e.g. a monthly forecast will run once per month at the start of a new month, and every other time the Report is run it will use the stored Forecast output data. A Forecast can be manually re-ran using the "Refresh Forecast" button on the report.<br></em></strong></p><p><br></p><p>A bar chart or a line graph can be added to the report to show the predicted values. These will show as a faded dotted line if "Show the predicted values on the chart" is enabled.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjFiNmU2M2U2LTYzYmEtNDVmYy05YWI3LTkxNTQyMzk5NGYzZiJ9.wnxedRmJJ_Kg0diHQ_uwj4o2SnNxG5FmCczJVY1c_wU" class="fr-fic fr-fil fr-dib" width="1209" style="width: 1211px; height: 583.353px;" height="583"></p><p><strong><span style="font-size: 10pt;">Fig 22. Predicted values on a line chart.</span></strong></p><p><br></p><p>If the checkbox for "Carry forward last value" is enabled on the Chart Setup tab, this allows you to plot a running total on the chart. For example showing increasing counts, revenue or costs over time. The Forecasting model should predict the value per period rather than the running total, then this option gives a visual representation of the running total.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImZjZDk5MDQ1LTM1ZjgtNDE0MC1iNDAyLWZlZDY5MzZlYzQ2NSJ9.9hg4Bl1Trieb0Mv1xWcIfAdOPn3541CVzbHC94Kxi8U" class="fr-fic fr-fil fr-dib" width="1041" height="510"></p><p><strong><span style="font-size: 10pt;">Fig 23. Same chart with the "Carry forward last value" option enabled.</span></strong></p><p><br></p><p>Scrolling to the end of the report will show an additional table if "Show the predicted values in a table" is enabled. It will show each period, alongside the predicted value.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6Ijc5ZTU0YTgwLWE3ZjQtNDQ4Mi04MWEzLTQzNDk1MTZkODg1YiJ9.qTl5vn07VfBvu5NmOFD_VFLlOs9N4d76Qa_cVw0UQeU" class="fr-fic fr-fil fr-dib" width="1216" style="width: 1218px; height: 731.884px;" height="732"></p><p><strong><span style="font-size: 10pt;">Fig 24. Predicted values in a table.</span></strong></p><p><br></p><p>The predicted values table and chart are also available on dashboards, on the end-user portal, and in report prints. The table can be added to Report prints using the $-REPORTFORECASTDATA variable.</p>
