Stacked Bar Chart - Closed vs Open

[jmonroe918]

I am creating a stacked bar chart that will display a list of Sites as my dimension and whether the site has open vs closed Status of Audits performed. There is a "closed" status and then there are several "open" status. What expressions do I use for the two parts of the stacked bars?

[MK_QSL]

Let us know the dimensions related to your questions.

Also, are you going to count number of sited open or close?

Let me give you an example which will give you count of Orders by date...

Dimension = Date

Expression 1 = COUNT({<OrderStatus = {'Open'}>}OrderID)

Expression 2 = COUNT({<OrderStatus = {'Close'}>}OrderID)

[manojkulkarni]

is it possible to post qvw file or sample data ?

[sujeetsingh]

Use two dimension one site and then the Status

[jmonroe918]

Manish:

Thanks for the response. It think the expressions you created are what I need, however Expression 1 needs to be any record that is not 'Closed'. There are other statuses (Originiation, Investigation, etc). How do I work the modifhier to exclude "Closed". Here are my expressions:

  Closed audits:

= COUNT({<[Internal Audits.Status] = {'Closed'}>}[Internal Audits.Audit No])

Open (not closed) audits

  = COUNT({<[Internal Audits.Status] - {'*Closed*'}>}[Internal Audits.Audit No])

I'm getting an error in the second expression.

Thanks.

Jeff

[jmonroe918 · Accepted solution]

Manish:

I couldn’t figure out how to attach the file, so I decided to email it to you until I figure it out.

Thanks.

Jeff

[MK_QSL]

<> in Set Analysis -=

  = COUNT({<[Internal Audits.Status] -= {'Closed'}>}[Internal Audits.Audit No])

[jmonroe918]

Manish:

That worked. Thanks a lot.

Jeff

[#9]

how will you calculate    open =Findings+Origination

[MK_QSL]

Glad that my answer helped you.

Kindly close this thread by selecting correct answer.