Pie Char with Aggr

[#1]

Hi,

I want to create a simple pie chart for zone dim with the expression in bellow table.

In this table I have 2 dimensions, but for pie chart I only want to see Zone Dim.

I tryed with an Aggr for AssetID expression but there was a error...

Any suggestions...

Thks.

[Anonymous]

Please post expression,so can help.

is the expression same as in table?

[Anonymous]

Hi!

If I have understood your question, you can try this:

=sum(distinct Zone_W)*sum(distinct Asset_W)

Let me know!

KR

Elena

[#4]

Can you explain what values would you like to see in the charts so We can understand better your requirement?

[rwunderlich]

If I understand correctly, you should just use Zone as the Dimension. The Expression should be:

sum(Zone_Weight * Asset_Weight)

Note the multiplication is done within the sum().

-Rob

[#6 · Accepted solution]

Sorry, about the late response!

I was doint something wrong in the data model, that was my error...

Tkhs.