Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have this table
LOAD * INLINE [
Date, Code, Number
01.01.2019, TRUE, 7
01.01.2019, FAULT1, 3
01.01.2019, FAULT2, 1
01.02.2019, TRUE, 7
01.03.2019, TRUE, 7
01.03.2019, FAULT1, 2
];
I would like a view giving
date;% fault1;% fault2
01.01.2019;3/7;1/7
01.02.2019;
01.03.2019;2/7;
any idea ?
Create a straight table with Date as dimension and use the following expresions
MaxString({<Code={'FAULT1'}>}Number)
/
MaxString({<Code={'TRUE'}>}Number)
MaxString({<Code={'FAULT2'}>}Number)
/
MaxString({<Code={'TRUE'}>}Number)