RE: Calculated Field vs Avg of Overall

quick question. I am trying to calculate days of cover inventory in quick sight. The way I am currently doing it is through creating a calculated field and getting sum(daily inventory) / sum(daily forecast) . Now, one of the Manager mentioned they wanted to get the avg of not overall but calculate this in query and get just consider avg of that number which I believe is biased so just wanted to know if you have came across this scenario and what do you do usually or if you know someone who can help me out in this ?

Hi @parthprj
did you check

maybe you can use that function?
BR

1 Like

Hi @parthprj

It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.

If we don’t hear back within the next 3 business days, we’ll proceed with closing this topic.

Hi @parthprj

Since we have not heard back from you, I’ll go ahead and close this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.

Thank you!