Help

[panipat1990]

Hi Team,

I have a requirement.i have a data from 2000 to 2016.. i want to make stacked bar chart where i want to show in dimension field in year from 2012 to 2016..but in 2012 bar show sum of 2000 to 2011 Value in half bar .and other half bar 2012 value...same as 2013,2014,2015,2016 ..... for this  i am sharing excel where value from 2000 to 2016 ...kindly help me.

Year            Id

2000            1

2001            2

2002            3

2003            4

2004             5

2005             6

2006             7

2007             8

2008             9

2009            10

2010             11

2011               12

2012              13

2013                 14

2014                15

2015                 16

2016                 17

When i select on 2012 then it show count of id from 2000 to 20111 in half bar ..other half bar show 2012 value like 13....same as 2013,2014

[Anil_Babu_Samineni]

Gourav,

Is your Dimension is what?

Meantime, Can i know what expression you are written over there?

- Anil

[panipat1990]

year is my dimension..

[sunny_talwar]

What you say same as in 2013... would it sum the count of ids for 2000 till 2012 or 2001 till 2012??? I think you need to provide more details as to what the final product needs to look like.

Doing this in the script works for you or do you need a front end option here?

[Anil_Babu_Samineni]

Sunny,

1) Might be he want to achieve if we select 2013 Data he want to show like Starting Year - 2013 / 2012 (Depends on Calendar) ?

2) If data has Year with 2000 to 2016 ( If we select 2003 he want to show from 2000 to 2003 / 2002)

- Anil

[Anonymous]

Hi Gourav,

See attached.

Regards!!

[Anil_Babu_Samineni]

Manuel,

In this scenario if Customer select 2001 i want to show 2000 & 2001 Data

Meantime, If Customer select the 2005 i want to show 2000, 2001, 2002, 2003, 2004, 2005 Data

Can i know what is the Expression to achieve this???

[Anonymous]

Hi Anil,

For not accum: sum({<Year = {'<=$(=Max(Year))'}>}EmpID)

For accum: RangeSum(if(Year =  vMaxYear, sum({<Year = {'=$(=Max(Year))'}>}EmpID)),sum({1<Year = p({1<Year={'<$(vMaxYear)'}>} Year)>}EmpID))

Regards!

[Anil_Babu_Samineni]

Nice Explanation,

If i want to show when document is opened with Selection of 2006 Data Directly?

[Anonymous]

Hi Anil,

You need to create a trigger when document is open:

Document Properties -> Triggers -> Document Event Triggers -> OnOpen -> AddAction.

Add an action to Select In Field ->

     Field -> Year

     Search String -> 2016 (if it is manually), Year(Today()) (if you wanna it dynamic)

Regards!