Skip to main content
Solved

Dashboard colunn chart - show months with no data

  • 30 September 2021
  • 1 reply
  • 109 views

Hi Acumatica community!

I have a column chart in a dashboard that shows sales by month for individual customers. The column chart only displays months with sales data, which is a problem as many of our customers order every second month or quarterly. See example below.

If there are no sales in a given month, I’d prefer that the chart showed zero (a blank space) for that month. This would make it much easier to see the relationship between sales and time.

Is that possible in Acumatica?

 

Hi @peterj23 ! Usually for these types of requests, because the ARInvoice table doesn’t hold data for periods where there was no activity, you’ll need to join in ARHistoryByPeriod and make sure to display all periods even if there is no activity, then the widget will pick up this information.

https://help-2021r1.acumatica.com/(W(797))/Help?ScreenId=ShowWiki&pageid=546521ef-49a4-198f-36b4-5073cefa16b6

“If some financial period does not have any transactions, the historical record will not be created for that period. In order to get the historical balance for such period you need to join the last historical record to the desired period. In reports, it is done with BaseARHistoryByPeriod, which is a business query language (BQL) projection.”

There is an example of joining to HistoryByPeriod table in the GL DAC overview:

 

Reply


Terms & ConditionsCookie settings