Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
danieldors
Contributor III
Contributor III

Production per Business Days

Hello,

Im looking to calculate the average production per day using networkdays for the current month. The data is cumulative of the current month only pulled weekly. End of week 1 would like to show the average total transaction for that week and so on. Thank you.

1 Reply
caiogil1
Contributor III
Contributor III

Hi @danieldors ,

Taking only what you said, maybe this can be close to what you may need (see attachment). If you can share some data sample, will be easier to understand and help you.

=Avg( Aggr( sum([Production]) / NetWorkDays(Min([DateProd]),Max([DateProd])), [WeekProd]) )

 

I hope to learn a lot here and help if I can