Skip to main content
Question

How to create a date range

  • August 23, 2019
  • 12 replies
  • 15 views
joos.buijs
Level 10
Forum|alt.badge.img+2

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.

12 replies

B
Level 0

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

marielouise.miesc
Level 6

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

Marie
B
Level 0
Hi Marie, up until now I havent heard any news. But maybe I can help you otherwise! Can you describe your task a little bit more in depth? Regards, Benedict
marielouise.miesc
Level 6

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

Marie
marielouise.miesc
Level 6

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.

Marie
F
Level 0

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

D
Level 1
Forum|alt.badge.img+2

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:

https://pql.eu-1.celonis.cloud/process-mining/public/105139f8-2fa6-4ef2-b2e0-c33299e3f7e7/#/frontend/documents/105139f8-2fa6-4ef2-b2e0-c33299e3f7e7/view

Cheers

David

joos.buijs
Level 10
Forum|alt.badge.img+2
  • joos.buijs
  • Author
  • Level 10
  • March 31, 2020
Great to read David! Any idea if/whether this will also come to the on-premise version of Celonis? (and if so, in a SP or in 4.7?) Cheers, Joos
D
Level 1
Forum|alt.badge.img+2
Hi Joos, it will come to on-prem, and Im sure it will be included in the 4.7 release. Best David
joos.buijs
Level 10
Forum|alt.badge.img+2
  • joos.buijs
  • Author
  • Level 10
  • October 6, 2020
Any more confirmation for the 4.7 inclusion? This feature is getting more and more important (/crucial) for us to provide clear insights.
D
Level 1
Forum|alt.badge.img+2
Hi Joos, yes, RANGE_APPEND will be available in the CPM4.7 release. Cheers David
W
Level 1

Where are we with this? I'm surprised that this haven't been answered in 4 years.

Community Code of ConductAccessibility statement