Help with a Line Chart

Sun, 03 Feb 2013 04:19:40 GMT

Hey guys, it's my first post.

I need help with a line chart that I am doing.

I have the Dimension set to Fiscal Year - going from 2008, 2009, 2010, 20011, and 2012.

The expression is where I am having trouble.

My Data looks like this:

VRR is a % (out of 100) rating a Vender's (Supplier) Reliabilty.

Fiscal Year is a field in another chart

Supplier# is a keyfield throughout all of my data.

What I need to do is to make a Line Chart that plots the VRR from FY08 - FY12 But I do not know how to set up the Expression, Any help out there?

Do I need to set up a new field or a variable that tells the Line Chart from which VRR box to draw data from?

Re: Help with a Line Chart

Mon, 04 Feb 2013 04:29:35 GMT

Have you tried building a line chart with the dimensions fiscal year and supplier and an expression like sum(VRR)?

This would show VRR per supplier and year.

Hope that helps.

Matt