Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
In the encosed document I want to count number of Node Id's for each Object and Tech and for the last week available.
I've tried to use this expresion but If I select several weeks the result will be aggregated
*=Count ({<Tech= {'3'} >}[Node Id])*
How can this be done?
OK.
Here it is
Where is Tech in this qvw?
It's incuded in the expressions. e.g. "4 Availability" is showing data for G4
e.g "MCDR (4)" looks like this:
=num(100-((sum({<Tech= {'G4'} >} [Call Fails])+sum({<Tech= {'G4'} >}[Call Drops]))/sum({<Tech= {'G4'} >}[Call Attempts]))*100,'# ##0,00')