How can I have a common table on the temporary table from GENERATE_RANGE function and the case table

Question

Hello,

I need a line chart showing created/open/resolved cases count every day.

For x axis, I used GENERATE_RANGE function to generate DATE values as below.

GENERATE_RANGE ( '1D' , TO_DATE ('2024-01-01', FORMAT('%Y-%m-%d')), TODAY())

For y axis(KPI), I use:

COUNT_TABLE ( "casetable" )

However, the problem is there's no common table between this generated temporary table with the case table or activity table, so the case counts cannot be calculated based on this temporary table.

Does anyone know a good way to create that analysis, ideally only in frontend and not change the data model?

florian.mrkvi · Answer

Hi!Iam not sure why you aretrying to useg theGENERATE_RANGE function for the x-axis. Normally you would use a date field from your case table which is already there or which is being added by a PULL_UP function.If you just generate a date range (x-axis) Celonis doesn’t know which day thecase belongs to. At least in your description I can’t see any date that belongs to the case. Where isthe date info stored for eachcase?

Reply

ANY QUESTION?

MORE CELONIS

CHECK US IN

Reply

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded

ANY QUESTION?

MORE CELONIS

CHECK US IN