Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

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
Highlighted
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