Ability to display 0 for periods that don't have data on the database

What is the problem or goal the end user is trying to solve or accomplish?

Users create visualizations based on their data, and would like to visualize on the Chart periods that don't have any data indicated as 0 . For example, when aggregating data in weeks, users would like to include weeks that have no data on the DB.

How are they solving it currently?

Users need to create complex SQL queries to include weeks that have no data on the Chart for visualization.

What is the recommended solution by the Customer?

Provide the ability to include (or not) time periods that don't have data indicated with 0.