Use output from One Chart as Input to Another

[Anonymous]

Hi

I have a straight table(Sample attached) where i am calculating value  of a column(Averted Cost) using the below formula:

REMDAYS*SUM(CX_MINUTES* CX_RATE)

the field REMDAYS is a number which is calculated using a Load statement in the editor(This number is the difference between 2 dates and varies per account).

I want to create another straight table, which will calculate the Sum of Averted Loss on a monthly basis. How can i do that?

I am able to get the SUM of Customer Cost as this is taken from the DB directly, but as the Averted Cost is calculated using a function, how can we use that?

Thanks

Taher

[vishsaggi]

Could not find any sample attached. Can you re upload please?

[rubenmarin · Accepted solution]

Hi Taher, to do a table eith month as dimension (and no customer) you can add an aggr() to calculate the value per customer, and sum the value of all customers:

Sum(Aggr(REMDAYS*SUM(CX_MINUTES* CX_RATE), MonthField, CustomerField))

[Anonymous]

He Vishwarath,

I attached the image instead.

[Anonymous]

Hi Ruben,

This worked. Thanks a lot.

Taher