We are plotting numbers of cases finished per date. However, when there are no cases
finished on a particular date, the date is not present in the chart, and hence were losing information.
A solution could be to create a data range, say from all days between 1-1-2019 and TODAY(), making sure that every day is represented in the chart.
We have similar issues when plotting on hour of the day (0-24), day of the week (0-6), etc.
Hey Joos,
Thank you for this feature request! We are currently developing on this topic, so keep an eye out for the change logs in the next few months, as we have internal and external use cases for this function.
Best Regards,
Benedict
Hello Benedict,
is there any progress on that topic. Creating a table with RANGE() is possible but I am not able to then calculate no. of cases per day or something. Everything is grouped by the starting date of the RANGE() function.
Best Regards,
Marie
Hi Benedict,
it is the same use case as described by @joosbuijs I would like to have a chart which has one value for every day or hour (for example n.o. produced parts in a certain area) and if there is no value because we did not have an event during that day / hour I would like the chart going down to 0 and not cutting out the timeframe without events. Cutting out leads to miss interpretations. If we had a planned downtime for the weekend the chart would not visualize the break between friday and monday.
Marie
2020-01-21 13_32_24-Mappe1 - Excel821773 18.6 KB
If we do not have Cases running over Activity Start on Saturdays and Sundays we are not able to create the 0 values or customize the x-axis. That leads to missunderstandings and missinterpretations of the data.
Hi,
I have a similar case. I would like see if one activity is periodic, treated by batch or if there is a campaign effect.
Then when you got the solution, let me know.
Thanks.
Fred
Hi everyone,
Im happy to announce that this feature is now available in the IBC.
We added the new RANGE_APPEND function, which takes a column and appends all values inside a given range with a given step size to that column. Just take a look at the corresponding page in the IBC documentation here: help.celonis.cloud/help/display/CIBC/RANGE_APPEND
Or check out the following example:
Cheers
David
Where are we with this? I'm surprised that this haven't been answered in 4 years.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
