Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
bouderbc
Creator
Creator

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

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

11 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

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
Creator
Creator
Author

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 ?