How to generate a calculated field with count ( ) or Sum in the load script ?

[bouderbc]

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

[Peter_Cammaert · Accepted solution]

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

[bouderbc]

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 ?