To count no. of dealers in a field and used this as dimension in chart

[Anonymous]

I need to count no. of Store_Code available per ZSM . And used this expression as a dimension in chart.

Table:

LOAD SECCode,

     Username,

     StoreID,

     Key,

    Store_Code,

     Store_Name,

     UserResponse,

     SurveyDate,

     CountershareType,

     CompetitorName,

     Flag,

     Qty,

     DP

     Resident CompetitorResponse;

left keep(DigitalLogbook_CounterShare_SEC)

Sales_Hierarchy:

LOAD

     Upper(Dealer_Code) as DealerCode,

     Upper(Dealer_Code) as Store_Code,

      ZSM_Code,

     Capitalize(ZSM_Name) as ZSM_Name,

      ABM_Code,

     Capitalize(ABM_Name) as ABM_Name,

     RSO_Code,

     Capitalize(RSO_Name) as RSO_Name

FROM

$(STAGE1_MASTER_QVD_PATH)AllindiaMaster.qvd

(qvd) Where Dealer_Status = 'Active';

[Anonymous]

Table:

LOAD SECCode,

     Username,

     StoreID,

     Key,

    Store_Code,

     Store_Name,

     UserResponse,

     SurveyDate,

     CountershareType,

     CompetitorName,

     Flag,

     Qty,

     DP

     Resident CompetitorResponse;

left keep(Table)

Sales_Hierarchy:

LOAD

     Upper(Dealer_Code) as DealerCode,

     Upper(Dealer_Code) as Store_Code,

      ZSM_Code,

     Capitalize(ZSM_Name) as ZSM_Name,

      ABM_Code,

     Capitalize(ABM_Name) as ABM_Name,

     RSO_Code,

     Capitalize(RSO_Name) as RSO_Name

FROM

$(STAGE1_MASTER_QVD_PATH)AllindiaMaster.qvd

(qvd) Where Dealer_Status = 'Active';

[sunny_talwar]

So what is the issue you are running into?

[Anonymous]

I need count(Storecode) as OL_Count as a dimension in chart . when i m doing this in front end as a calulated dimension against ZSM_Name

i m getting an error

[sunny_talwar · Accepted solution]

Are you doing something like this?

Aggr(Count(Storecode), ZSM_Name)