Calculated Expression - Line Chart

[jmonroe918]

Attached is a table of data that I want to use for creating a line chart. I want to use "Yr/Mon" as the dimension. I want to calculate the overall combined (for all sites) complaints per million: (sum of complaints/sum of shipments)*1,000,000 for each Yr/Mon. I would also like when I select a site, it calculates the CPM for each Yr/Mon for that site alone.

What is the expression calcuation? I know it's not a matter of adding up the CPMs.

Thanks.

Jeff

[Gysbert_Wassenaar · Accepted solution]

The expression is simply sum(Complaints)/sum(Shipments)*1000000. Use Yr/Month as dimension for the line chart. Add a listbox for Site to select the sites. See attached qvw.

[jmonroe918]

Gysbert:

Did you attache at file?

Jeff

[sundarakumar]

Hi Jeffrey,

The file has been attached by Gysbert,

Guess u r seeing the reply through mail,

Please login to see the attachment.

-Sundar

[jmonroe918]

Sundar:

I haven't seen any attachment in this post. Where would it be?

Jeff

[jmonroe918]

Sundar:

Never mind. I found it.

Thanks.

Jeff

[sundarakumar]