two in single bar

[soniasweety]

Hi all,

I have a bar chart  with one dimension and  two measures

dim:country

measures:1. count(country)

2. avg(sales)

if I  use this   am getting two bars   

but my requirement is    I want to show two in single bar  [but not stack]

because stack will show the accumulate values

-- avg(Sales)  it should show one bar  and on top I want to show only count(country)    not as bar  only count.

Thanks

Sony

[soniasweety]

what it means andy?

[ogster1974]

If your first mesure is 80 and your second 100 and you want to stack it but only to a height of 100 then take the second measure and subtract first measure so you stack the 20 on the 80.  Its a fudge but gets you closure.  Id go with the combo chart example I gave with the 2 axis and the measures identified as seperate visualisations.  It confuses me when people want to combine 2 different measures and make it look like part of the same measure.

[soniasweety]

nice andy,

but I have created a combo chart   but I need values on data point?

[ogster1974]

users hover over on the Sense combo to avoid cluttering the visualisation with numbers.

Regards

Andy

[soniasweety]

yes but user is very complex

tomorrow I need to show then I will come back on this