Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hope someone can help me
have to create a pie chart with following expression :
Have following field names :
Shfit | Contract | Mch_code | Work_Type_ID |
---|---|---|---|
S0 | ANTWERP | NAT_TR | OPERLO |
S1 | BRUSSELS | NAT_WG | OPERLO |
S1 | ANTWERP | SH01234 | OPERLA |
S2 | BRUSSELS | NAT_WG | OPERLA |
Need to create a pie chart for only the items with Mch_code SH* and counting result SH01234 1
Need to create a pie chart for only the items with Mch_code NAT* and counting result NAT_TR 1 & NAT_WG 2
Can someone help me with creating the set analysis ?
Tks for yr help
Rudi
hello
try this one for the first one count({$<Mch_code= {"SH*"}>}Shfit) and this for the second chart
count({$<Mch_code= {"NAT*"}>}Shfit). and let me know
Hey
Tks for your reply
Shfit is red underline and getting no result
oke its working changed shfit into Std_job_id
Tks for yr help
great, happy to help!