Barchart help

[shree909]

Hi i have a bar chart with company name and year id as dimensions and one metric

for year id i have 5 years,0,1,2,3,4,. the problem is when i display the chart  and show values on data points that works perfect.

the issue is i want to show the datapoint values for only  0 yr and remaining values should be hidden

can this be done, help needed

[avastani]

if you want to show data point for only Year 0 but still show all other point... then use another expression with set analysis for Year={0}

use Calculated Dimension.

if(Year = 0, Year)

[MayilVahanan]

Hi

     You can use text in chart properties in Presentation tab..I think show values on data point is have no option like that..

     something like in "text in chart properites"=sum({<Year = {0}>}Sales)

Hope it helps.

[shree909]

thanks for the reply, but i want to show all the years but datapoints should be shown for 0 yr on the graph remioaning yr datapoints on graph should be hidden,

in bar chart  expressions tab , we have 'values on datapoints'. when i chak that i shows for all the years.

i want to restrict to only one year

[avastani]

Please clarify with a visual in excel.

Do you want a trend line for all years but Data Point marking Year 0 with a Dot?

Or do you want data to show only for Year 0 and nothing else?

If the latter, then classic set analysis does the trick SUM({ Sales). Even calculated dimension works with If(Year = 0, Year)

Thanks.

Amir.

=====================

Amirali Vastani

Tel: 646.773.7936

[#6 · Accepted solution]

Hi Shree,

You can expand the expression by clicking on the + sign, then select the option "show value" and on the righit hand side, in the defenition area write your condition based on which the value should be shown. in your case yr=0

Regards

Satheesh

[shree909]

this is how it should shown on graph

[MayilVahanan]

Hi

     You can try like this,

     use company name as dimension and use five expression for years like

     =sum({<Year = {0}>}sales)

     = Sum({<Year = {1}>}sales) like this..

     and tick value on show point for first expression

hope it helps

[shree909]

Thanks guys, it works  perfect

[avastani]

What I mentioned about second expression shudl do the trick. use combo chart. should do fine. or the show value trick will also do it.