Filtering on 1 machine --> giving the values of every machine it's coupled with

[Anonymous]

Hey,

I made a report giving the output of different machines. 

But sometimes 1 operator is working on multiple machines at the same time.

In my report I would want the possibility to filter on 1 machine and see what the output is for that machine but also every machine it has coupled with. 

I can't just add those machines in the slicer, cause then I also get all the machines those others coupled with as well.

e.g.

Now: When I filter on machine1 I get all the machines it coupled with (or it worked alone). But when filtering, I only get the velocity of the machine I filtered on.

When I also select machine 16 and 20 (cause machine1 coupled with those), I get this:

But actually, with this filter I'm not interested in those in red, because those didn't run with machine 1.

note: It's okay that KBTF01, KBTF16,KBTF20 is not visible in the first table, because there is actually no output (we just know that when the operator was working on KBT20,  he was also logged on on KBTF01 and KBTF16 without production.

Thanks in advance!

[HoangHugo]

You can use Filter panel, to set "KoppelMachine" only show items contain "KBTF01" by using advance filter like picture below

[Anonymous]

Thank you for this possible answer! I hadn't thought about that yet 🙈.

Is there a possiblity to have such a filter with the visuals instead of the filter panel?

[HoangHugo]

yes, you can Calculate your Mearsure to show items contain " KBTF01" like below

New_measure = CALCULATE (your fomula, SEARCH("KBTF01",Kopplemachine column,1,blank())>1)

[Anonymous]

I haven't used this before. But it needs to be interchangable to another machine. And I have 60 machines. So it needs to be a kind of slicer.