RE: In And Out

[Chanty4u]

hi all,

i need the  bar chart

incount in %   is: no of people walkin into

outcount % :no .of people walked out

i hve tried with the expresion but i didnt get

exp output:  the image i hve attached  with the vallues   in %..

thanks in advance

suresh

[Chanty4u]

hi sunny

Sunny T

can u look into this once..

[sunny_talwar]

Looking into this now

[Chanty4u]

Hmm the issue is the expression that shwng the values in wrng format... i need in % format..

[sunny_talwar]

i hve tried with the expresion but i didnt get

What have you already tried? Can't see anything in the attached qvw brother

[Chanty4u]

just i need the  incount and outcount ....am nt getting the expressions for that and the chart which i hve in image exactly i want...

[Chanty4u]

hi sunny,

updated

[sunny_talwar · Accepted solution]

This?

Expression1: Sum(Incount)/Sum(TOTAL Incount)

Expression2: Sum(Outcount)/Sum(TOTAL Outcount)

[Chanty4u]

in combo chart also... the second expression is nt shwng exactly...what is the issue?

[sunny_talwar]

Your cycle groups (dimension) uses year, Month, Date which are all from a non-linked table. So there is a implicit Cartesian product in your database which is why you see the sum(Total_sales) for both the years. Same is true for the second expression.