Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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';
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';
So what is the issue you are running into?
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
Are you doing something like this?
Aggr(Count(Storecode), ZSM_Name)