Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone
i have a field i call availability of which I've calculated so i want to find the average of that calculated field to be on the text object like this
i did a total mode(choosing average per row ) of the calculated measure availability on straight table i got this, so i want the 96.64 to be on the text object like above one.
Thank you in advance
How is your expression looks like?
What is your dimension and your expression? Try this
Avg(Aggr(Expression, Dimension))
Copy your Average Availability metric and on text box and plot percentage expression.
1-((sum(Downtime)/(sum({<avail_FLAG={'WeekDay'}>}Avail_Time)*(sum(IsWorkingDay))+sum({<avail_FLAG={'Saturday'}>}Avail_Time)*(sum(IsSaturday))+sum({<avail_FLAG={'Sunday'}>}Avail_Time)*(sum(IsSunday)))))
What about your dimension? How many dimensions do you have and what are there names?
my dim is application number and my expression is the one below(availability/count(application_ID)
1-((sum(Downtime)/(sum({<avail_FLAG={'WeekDay'}>}Avail_Time)*(sum(IsWorkingDay))+sum({<avail_FLAG={'Saturday'}>}Avail_Time)*(sum(IsSaturday))+sum({<avail_FLAG={'Sunday'}>}Avail_Time)*(sum(IsSunday))))) /Count(Application_ID)
Try this
Avg(Aggr(1-((sum(Downtime)/(sum({<avail_FLAG={'WeekDay'}>}Avail_Time)*(sum(IsWorkingDay))+sum({<avail_FLAG={'Saturday'}>}Avail_Time)*(sum(IsSaturday))+sum({<avail_FLAG={'Sunday'}>}Avail_Time)*(sum(IsSunday))))) /Count(Application_ID), [Application Number]))
To get that value, choose "Expression Total" for the total mode for the expression.