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

[microwin88x]

Hello,

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

• Anomaly: COUNT({$<FLAG_STATUS={"Anomaly"}>} DISTINCT %ACCT_ID)
• No Anomaly: COUNT({$<FLAG_STATUS={"No Anomaly"}>} DISTINCT %ACCT_ID)
• Total: [Anomaly]+[No Anomaly]
• Effectiveness: [Anomaly]/[Total]

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

Chart 1:

• X Axis: Effectiveness values
• Y Axis: # of Cases

Chart 2:

• X Axis: Total values
• Y Axis: # of Cases

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!

[MK_QSL · Accepted solution]

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