Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts !
I want to generate a calculated column in the load script to use it in my set analysis
Case :
I want to load this expression as a column
Expression:
=Count({<[State] = {'UK'}>} [Customer])
Example:
=Count({<[State] = {'UK'}>} [Customer]) as UK_CUSTOMERS
Please tell me how can i do that ?
Regards
Ali
Add this after your LOAD statement:
LEFT JOIN (Security)
LOAD Client,
100.0*Count(IF (EtatBitLockerChiffrement = 'conforme', Client))/Count(Client) AS TOTO
RESIDENT Security
GROUP BY Cliient;
Best,
Peter
Awesome , Thanx Peter ! I have another question :
i want to use the field TOTO which is a calculated field with the dimension month in a bar chart and show the last six months ? How can i do that ?