Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
i got a issue: i am using this Expression, for instance:
avg(aggr((Sum({<Projekt={"for one"}>}[Points]) / Sum({<Project={"for one"}>}[Scorepoint])),Project,SubProject))
and this Expression does work well.
my issue, how can i make this Expression as static, i mean, whatever i select within of my file (fields), i want that the result within this Expression still ignored (unchanged).
Does anybody have any idea?
Thanks a lot
Beck
Hi,
You do this by adding a field and a =. See the example: , [FieldForIgnoring] =
avg(aggr((Sum({<Projekt={"for one"}, [FieldForIgnoring] = >}[Points]) / Sum({<Project={"for one"}, [FieldForIgnoring] = >}[Scorepoint])),Project,SubProject))
Add all the fields that you want in here.
A bit more advanced, but if you have a lot of them, add them in a variable and put in this in the back-end. Put then the variable in the set analysis.
Jordy
Climber
Like:
avg({<Projekt={"for one"}>} aggr({<Projekt={"for one"}>} (Sum({<Projekt={"for one"}>}[Points]) / Sum({<Project={"for one"}>}[Scorepoint])),Project,SubProject))
Hi,
You do this by adding a field and a =. See the example: , [FieldForIgnoring] =
avg(aggr((Sum({<Projekt={"for one"}, [FieldForIgnoring] = >}[Points]) / Sum({<Project={"for one"}, [FieldForIgnoring] = >}[Scorepoint])),Project,SubProject))
Add all the fields that you want in here.
A bit more advanced, but if you have a lot of them, add them in a variable and put in this in the back-end. Put then the variable in the set analysis.
Jordy
Climber
Try putting your set analysis components in avg() and aggr() as well.
Hi Jordy,
thanks a lot for your Feedback, i have a Question: if i want to ignore the field: Subproject, although i have this field in my expression, i tried but it does not work. or am i missing something?
thanks a lot
Hi Tresesco,
thanks a lot for your Feedback, but i dind't catch what do you mean, can you Show me idea as example. thanks a lot
Like:
avg({<Projekt={"for one"}>} aggr({<Projekt={"for one"}>} (Sum({<Projekt={"for one"}>}[Points]) / Sum({<Project={"for one"}>}[Scorepoint])),Project,SubProject))
Hi Beck,
Also try the thing that @tresesco mentioned, because you need it. You don't need to force it again if it's the same field because you already forced it to 'for one'.
Add it in you avg/aggr and your formula will be as needed.
Jordy
Climber
Hi Tresesco,
thanks a lot for your help and time
Hi Jordy,
thanks a lot for your time and help