Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
my set-up looks like this:
DOKU_ID | WFL_STEP | USER | TSTAMP_RECEIVED | TSTAMP_SEND | ACTIVE |
---|---|---|---|---|---|
1 | A | Tim | 10.12.2013 | 11.12.2013 | 0 |
1 | B | John | 11.12.2013 | 13.12.2013 | 0 |
1 | C | Samantha | 13.12.2013 | 16.12.2013 | 0 |
1 | C | Gina | 13.12.2013 | 16.12.2013 | 0 |
1 | D | Tony | 16.12.2013 | 1 | |
2 | A | Samantha | 12.12.2013 | 14.12.2013 | 0 |
2 | B | John | 14.12.2013 | 1 | |
2 | B | Tony | 14.12.2013 | 1 | |
3 | A | Tim | 15.12.2013 | 1 | |
3 | A | Gina | 15.12.2013 | 1 |
I want a Pivot Chart with the Dimensions WFL_STEP and USER. The Functions should be TSTAMP_RECEIVED and TSTAMP_SEND. The Chart should just be visible if you select one DOKU_ID. This is possible to do for me. Now to my Problem: I want the Pivot Chart to ignore any selection on the field ACTIVE.
See attached file: I want now the Pivot Chart to show all Information to the DOKU_ID.
This might be easy to solve, but I got no solution. And ideas?
Thank you for helping me
Matthias
Have you tried Set Analysis to ignore selection on ACTIVE :
= only( { < ACTIVE=> } TSTAMP_RECEIVED )
= only( { < ACTIVE=> } TSTAMP_SEND )
Best Regards, Bill
Matthias
Have you tried Set Analysis to ignore selection on ACTIVE :
= only( { < ACTIVE=> } TSTAMP_RECEIVED )
= only( { < ACTIVE=> } TSTAMP_SEND )
Best Regards, Bill
Hi Bill,
thank you for your quick response.
No, I did not. I always tried to "manipulate" the dimension.
Matthias