expression combination

[#1]

Hey All

Need to make a combination expression :

Following expression is working

=count({<Date={">=$(vStartDate)<=$(vEndDate)"}>}SALES)

Date               UNLOAD_TO_DIRECTIVE               EDI

13/01/2014     EDI                                                EDI

13/01/2014     KLBIKK                                          KLBIKK

14/01/2014     BLE014                                          BLE014 

14/01/2014     EDI + 20                                         EDI + 20

Need the following overview - total of all directive and total of all EDI*

Date               UNLOAD_TO_DIRECTIVE               EDI

Total              4                                                   2

13/01/2014     2                                                   1

14/01/2014     2                                                   1

Can some help me out plse

Tks

Rudi

[MK_QSL]

can you briefly explain how below coming?

Date               UNLOAD_TO_DIRECTIVE               EDI

Total              4                                                   2

13/01/2014     2                                                   1

14/01/2014     2                                                   1

[#3]

UNLOAD_TO_DIRECTIVE = COUNT OF ALL ITEMS UNDER UNLOAD_TO_DIRECTIVE IN THIS CASE 4

EDI = COUNT OF EDI AND EDI* IN THIS CASE 2

[jagan · Accepted solution]

Hi,

Create a Straight table and try like this

Dimension : Date              

Expression 1 - Total of all Directive:

=count({<Date={">=$(vStartDate)<=$(vEndDate)"}>}SALES)

Expression 2 - Total of all EDI:

=count({<Date={">=$(vStartDate)<=$(vEndDate)"}, UNLOAD_TO_DIRECTIVE={'*EDI*'}>}SALES)

Now select Sum of Expressions option in

Chart Properties -> Expression tab.

Regards,

Jagan.

[Anonymous]

See attachment.