How the selections have no effect in a chart

[geogou1973]

Hello.

I have the following expression in a chart with COMPANY_NAME_HOURLY_CURRENT as dimension

sum(aggr(max(RETAIL_HOURLY_CURRENT),DATE_ID_HOURLY_CURRENT,COMPANY_NAME_HOURLY_CURRENT,ZAP_CODE_HOURLY_CURRENT))

how can i do selections in COMPANY_NAME_HOURLY_CURRENT that have no effect in the specific chart with this expression.

I tried the following with no result

sum({1}aggr(max(RETAIL_HOURLY_CURRENT),DATE_ID_HOURLY_CURRENT,COMPANY_NAME_HOURLY_CURRENT,ZAP_CODE_HOURLY_CURRENT))

and

sum({1<COMPANY_NAME_HOURLY_CURRENT=>}aggr(max(RETAIL_HOURLY_CURRENT),DATE_ID_HOURLY_CURRENT,COMPANY_NAME_HOURLY_CURRENT,ZAP_CODE_HOURLY_CURRENT))

and

sum({<COMPANY_NAME_HOURLY_CURRENT=>}aggr(max(RETAIL_HOURLY_CURRENT),DATE_ID_HOURLY_CURRENT,COMPANY_NAME_HOURLY_CURRENT,ZAP_CODE_HOURLY_CURRENT))

Also i don't want to use alternate state because the data changes when you change the date in the filter.

Thank you in advance.

[prma7799]

I think because of this {1} use $ sign to selection

[geogou1973]

Hello.

Does not work either.

[mayankraoka]

Hi ,

Can you try below expression:

sum({<COMPANY_NAME_HOURLY_CURRENT>}aggr({<COMPANY_NAME_HOURLY_CURRENT>}max(RETAIL_HOURLY_CURRENT),DATE_ID_HOURLY_CURRENT,COMPANY_NAME_HOURLY_CURRENT,ZAP_CODE_HOURLY_CURRENT))

and

sum({<COMPANY_NAME_HOURLY_CURRENT>}aggr({<COMPANY_NAME_HOURLY_CURRENT>}max(RETAIL_HOURLY_CURRENT),DATE_ID_HOURLY_CURRENT,COMPANY_NAME_HOURLY_CURRENT,ZAP_CODE_HOURLY_CURRENT))

and

sum({<COMPANY_NAME_HOURLY_CURRENT>}aggr({<COMPANY_NAME_HOURLY_CURRENT>}max(RETAIL_HOURLY_CURRENT),DATE_ID_HOURLY_CURRENT,COMPANY_NAME_HOURLY_CURRENT,ZAP_CODE_HOURLY_CURRENT))