Variable (with Set Analysis) as Dimension for a Chart?

microwin88x — Tue, 24 Feb 2015 11:05:50 GMT

Hello,

I have a Straight Table with the Dimension NAME and the following Expressions:

That works great! But now I was requested to create some Line Charts:

Chart 1:

Chart 2:

The thing is that I have the Effectiveness and the Total calculated as Expressions and I need to use them as Dimensions for Charts.

Is there any way to create Variables, for example, to store the Set Analysis clauses and then use them as a Dimension in the Chart?

Or do you know any other solution to help me out to solve this?

Thanks!

Re: Variable (with Set Analysis) as Dimension for a Chart?

MK_QSL — Tue, 24 Feb 2015 11:08:28 GMT

CHART 1

Create a Calculated Dimension as Below

Aggr(COUNT({$<FLAG_STATUS={"Anomaly"}>} DISTINCT %ACCT_ID) /

(COUNT({$<FLAG_STATUS={"Anomaly"}>} DISTINCT %ACCT_ID)

COUNT({$<FLAG_STATUS={"No Anomaly"}>} DISTINCT %ACCT_ID)),%ACCT_ID)

expression

COUNT(DIstinct %ACCT_ID)

CHART 2

Create accordingly