Total function with weekday function

[AdamT]

hi experts, 

i want to calculate the closed items in a day, divided by the day it was opened at.
say, the items that were closed in Monday and were opened in Sunday divided by the amount of items opened in Sunday.

I define the two dimensions as - 

weekday(opened_at)

weekday(resolved_at)

and the measure as -

count (distinct number) / count (distinct total <weekday(opened_at)> number)

I get the next error - 

Error in expression '>' expcted

any idea why? when i don't use the weekday function it works but that way I don't get the calculation I want 😞

THX a lot for your help!

[Or · Accepted solution]

You can't place a function in a total < > qualifier. You have to use a field. If you want to use Weekday(opened_at), create this as a field in your script and then use the new field in your count().

[AdamT]

Worked!

Thank you so much 🙂