error in expression

[#1]

I create a line chart  my expression is ::: Avg({[GROUP1]<[Gender]=Female >}UserScore_score)   it show the error in expression GROUP1 is Alternate state plz correct me.

Thanks

MAdhu

[amit_saini]

Josna,

Try this:

avg(distinct{$<Gender={'Female'}>}  UserScore_score)

avg({$<Gender={'Female'}>}  UserScore_score)

Thanks,
AS

[#3]

amit,

compulsory use alternate state

Thanks

Madhu

[jagan]

Hi,

Try this expression

Avg({[GROUP1]<[Gender]={'Female'} >}UserScore_score)

Hope this helps you.

Regards,

jagan.

[amit_saini]

Plz use group1 in place of distinct.

Thanks,
AS

[#6]

Hi,

Try this:

Avg({[GROUP1]}{<[Gender]={'Female'} >}UserScore_score)

[PradeepReddy]

try this..

Avg({[GROUP1]<Gender={'Female'}>}UserScore_score)

[Kushal_Chawda]

Just need below modification (in red) for your expression else it's fine

= Avg({[GROUP1]<[Gender]={'Female'} >}UserScore_score)