topic Re: Total function with weekday function in Search the Community

Total function with weekday function

AdamT — Wed, 15 Dec 2021 11:17:03 GMT

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!

Re: Total function with weekday function

Or — Wed, 15 Dec 2021 12:49:44 GMT

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().

Re: Total function with weekday function

AdamT — Wed, 15 Dec 2021 13:40:46 GMT

Worked!

Thank you so much 🙂