Hope you all doing all. Currently I'm facing some challenges in my current project regarding missing time data generation.
I've created a dummy data set to describe the issue. It would be great if anyone can provide a workable solution for the issue. The .qvw and dummy data file is available as attachment.
I want to show the trend of "No of Orders" placed for a particular Product in a Year. But the trend is showing data points for only those months when some data is present.
Below is the snap of current output and expected output-
Note: In real I'm dealing with 2 million records. So need to keep in mind the reload time and performance of the final application.
Thanks in advance. Cheers.