Networkdays as Dimmension (range)

[nlucia]

Hello everyone I need help to put ranges of networkdays as dimension. I have to calculate how many days it takes to assign a ticket between when the ticket is opened and when it is assigned (in business days)

"0-3 days"

"4- more days"

As they are tickets that are assigned more than once, within the formula I have to take into account that the date is the first assignment.

I am using the following function, which is not working for me (as dimension)

if(NetWorkDays( date(date_submitted)+1 , Min(if((old_value='new') and (field_name='status') and ((new_value='asigned')), (DATE(timestamp(date_modified/ 86400 + 25569))-time#(3,'hh'))))) <4,'0 to 3 days','4 or more')

But in the editor expresion is "acepted"

Thank you for your help!

[edwin]

you cant use the regular aggregation function in a dimension expression you need to use AGGR.  see pic:

table to the left i am using min of date as a measure.  in the right i am using aggr to get the min date as a dimension.

this is what it looks like if i use min as a dimension:

the expression builder will tell you the expression is correct as min(date) is a correct expression: min will accept date field as an argument.  syntactically right.