calculated field

[jjvigneC]

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 ?

[arpitkharkia]

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)