Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
so i have a scatter plot and i want to ignore values selected in a fiter pane.
The field i want to ignore: "Part"
What i tried:
The x axis in scatter plot:
sum( aggr( {<Part= >} [FCount], [SNr], Version, Name, Time, Path))
The y axis in scatter plot:
Aggr( {<Part= >} if(Duration <= Fractile({<Part = >} Total Duration, 0.99836), {<Part = >} Duration), [SNr], Version, Name, Time, Path)
And this dosent work.
Could you please help me with finding a solution?
Thanks
=Aggr(Only({1} If(Duration <= Fractile(Total Duration, 0.99836), Duration)), [SNr], Version, Name, Time, Path)
Try these:
=Sum({<Part=>} Aggr(Only({<Part= >} [FCount]), [SNr], Version, Name, Time, Path))
=Aggr(Only({1<If(Duration <= Fractile(Total Duration, 0.99836), Duration)), [SNr], Version, Name, Time, Path)
now it stopped working completely
where to close the "{" bracket?
=Aggr(Only({1} If(Duration <= Fractile(Total Duration, 0.99836), Duration)), [SNr], Version, Name, Time, Path)