Referencing an Expression

[Anonymous]

I have two expressions in a chart.  The first is "Nbr Customers" defined as COUNT(USER_ID).  The second expression is "Total Customers" defined as COUNT(USER_ID) with the "Full Accumulation" option set.  This provides a rolling total of the number of customers.

I need to be able to highlight the value of second expression ("Total Customers") when it reaches 70% of the total number of customers (COUNT(USER_ID) * .7).

Is there a way to reference the second expression with the Full Accumulation option set in another expression?  How do you code that expression with the Full Accumulation option set?

Thoughts?

Thanks,

Ed T.

[chrismarlow]

Not sure this would be exactly what you are after, but you could highlight using Visual Cues tab, and use TOTAL in the count to return total, something like;

[Colin-Albert · Accepted solution]

In the same chart, you can reference expressions by their label name. If the label contains spaces then you must add square brackets around the name.

e.g. In your chart you could add a third expression as

          =[Nbr Customers] / [Total Customers]

[terezagr]

You can do that in expression. Click on + sign next Expression(Total Customers) to expand the options.

Than in the background option add this expression:

=if((COUNT(USER_ID) * 0.7),RGB(red))

[Anonymous]

Thanks, Colin.  This is the syntax I was looking for.