Network Days in Script: Error

[stjernvd]

Hi,

I tried to create this in my script:

NetworkDays(Min(Date),Max(Date)) as BusDays

but it won't work.

I need BusDays field to be able to divide Sales/BusDays, since date isn't working days.

And I want this on a monthly basis, so that each month busdays amount will change.

How do I set this up? in my script or in the dashboard?

[marcus_sommer · Accepted solution]

Min/Max are aggregations which requires an aggreagtion-load with group by.

- Marcus