Every value from a specific field, while ignoring other fields selections

[LouisJ]

Hello,

Is there any way to get every value from a specific field, while ignoring other fields selections ?

For example I have [Type], [Location], [Date], [Time of Completion].

I would like to have a KPI block show the average [Time of Completion], for the selected [Type] (can be multiple), but this average should not change when [Location]/[Date] gets further selected (unless a [Location] removes a [Type] for example).

So if I had 2 possible [Type] values, the average should have 3 only possible values :

- [Type] 1 global [Location]&[Date] average on [Time of Completion]

- [Type] 2 '''''''

- [Type] 1 and 2 ''''''''''''

Thanks in advance,

LJ

[sidhiq91 · Accepted solution]

@LouisJ Please correct me if I am wrong. As per my understanding, you can use set analysis to get the desired result.

Avg({<[Type]={'Value1','Value2'}, [Location] =, [Date]=  >}[Time of Completion])

Field_name= will ignore any selection

If this resolves your issue please like and accept it as a solution, else let me know if you need anything else.

[LouisJ]

Hi, thanks for the input, that looks very promissing, could it be possible to make this formula dynamic by replacing [Type]={'Value1','Value2'} by some expression signifing "take values from the all possible types according to the users selection" ?

Something like : [Type]={'GetFieldSelections([Type])'} ? (but that works, I'm having trouble with set analysis syntax ...)

[LouisJ]

Ok it works ! I just had to replace the constant values by the field again !

Avg({<[Type]=[Type], [Location] =, [Date]=  >}[Time of Completion])

Thanks a lot for your help!

LJ