Calculating Daily Sale Order

Hello Dear All,

I am doing an analyze for a supplier companys inventory. The data-set is like this in the image below.

Screenshot 2020-01-07 at 14.08.041495829 62.5 KB

The data set is for the last 4 years, and I just want to calculate the daily cases for each product, for determining the amount of Sale order per day for each product.

I would appreciate if you could advice me a way to calculate avg daily sale order for each product id.

Thank you so much and have a nice working days

Page 1 / 1

OK, I solved the problem

By selecting Product_Id as a dimension in an OLAP table, and with this KPI formula:
COUNT_TABLE(PM.csv_CASES) / DATEDIFF(dd, MIN(PM.csv.Date), TODAY())
Peace

Thanks for posting your solution on here

Actually, according to the database of my case study, the last day is 2019-11-07. Is there a way to set a specific date instead of " TODAY() " ?
Thank you.

Nice, I also found how to do it

I could set a specific date for the KPI formulation by this code:
TO_TIMESTAMP(2019-11-07, YYYY-MM-DD)

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