Skip to main content
Question

Adding empty entries in column charts

  • July 17, 2019
  • 1 reply
  • 0 views
A
  • Anonymous
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

1 reply

B
Level 0
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
Terms & ConditionsAccessibility statement