How to set reference Line in a Cyclic Group?

[#1]

Hi All,

We have a Requirement as below,

in Bar chart we are using Cyclic group as dimension(which has year,Quarter, Month,Day Fields in cyclic group).

Now we have to set Reference Lines (Nothing But Targets) for each individual Fields.

for Eg. Year wise target should be 1000, Quarter it may 250, for month it is 84 like wise..

Kindly provide us a solution.

Thanks

[avinashelite]

Hi Reena,

As per my knowledge, you cannot you reference line with the groups(cyclic or drill down) .It can be use only on non-grouped dimension. You cannot fetch the particular selection of the group.

If you want to achieve it try with his approach.

Add a inline table having  values Year, Quarter etc.

Add four dimensions and hide them based on selection using conditional hiding.

Follow  the same in the reference line too. This will give you the desired representation.

Hope this helps you.

Regards,

@vi

[jagan · Accepted solution]

Hi Reena,

I am not able to fixed that in existing chart, but when I tried to create the new one it is working, used the following as reference line expression.

=Pick(Match(GetCurrentField(cgNewGroup), 'Year', 'Quarter'), 1000000, 500000)

Replace cgNewGroup with your group name.

Regards,

Jagan.

[#4]

Thanks Jagan its works...