Hi everyone,
we currently face the following issue while analyzing a product lifecycle. After a development project we added a sales activity, holding the sales volume. Showing the timestamps of that activity on the x-axis and the volume on the y-axis, we receive the development of the product.
This leads to the issue, if there are no sales in certain months, those months are not shown on the x-axis, meaning a year with sales each month is represented 12-times in the chart but a year with sales in only 2 months is represented only twice. This makes it impossible to read out trends on a case level.
As the dimension formula is a regular (ROUND_MONTH(XXX_ACTIVITY.EVENTTIME)), there could be a checkbox to fill missing month between the highest and lowest available month.
Best regards,
David
Page 1 / 1
Hey David,
This is a really good proposal!
As we started developing on this topic, expect an update of our PQL-Capabilities solving this issue this year (we will probably go for a solution with our existing RANGE()-Function and on a day basis, since you can always round on anything afterwards).
As always keep an eye out for the changelogs in our awesome feature & future updates.
Best Regards,
Benedict
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.