Comments on Dimension

[Anonymous]

Dear All,

I have a layout issue with respect to Pivot Table. There's a customer requirement where "comments" are to be given on a Field Dimension  - Bucket, as below:

16-45	Delayed (above 15 days)
8-15	Delayed (8 to 15 days)
2-7	Delayed (2 to 7 days)
0-1	will miss FFR in 1 days

On giving a random comment "abc" on Dimension, is displayed only over Dimension label.

Please assist in achieving this requirement.

Thanks,

Vijit

[tresesco]

Try InputField .

[its_anandrjs]

If this bucket is created in load script then add a sequence it for that and in chart properties use that sequence id for sorting

Eg:-

Bucket                                        SequenceId

0-1 will miss FFR in 1 days           1

2-7 Delayed (2 to 7 days)              2

8-15 Delayed (8 to 15 days)          3

16-45 Delayed (above 15 days)     4

Hope this helps

Thanks & Regards

[Anonymous]

Hi Anand,

How this will help in giving comments.

An Example to explain my requirement: If I roll mouse over the the Bukcet 16-45, "Delayed (above 15 Days)" as a comment must be diplayed.

Thanks,

Vijit

[its_anandrjs]

Create your flag like this

Eg:-

if(ID >= 0 and ID <= 3,'0-3-will miss FFR in 1 days',

if(ID >= 3 and ID <= 6,'3-6-Delayed (2 to 7 days)',

if(ID >= 6 and ID <= 8,'6-8-Delayed (8 to 15 days)'))) as Flag

and on chrt use subfield function like

=SubField(Flag,'-',3)

Then from 3 place you get commend script

Hope this helps

Thanks & Regards