Add count to chart

[former_member680965]

I have this table:

and I plotted a heat map like this:

But what I wanted was to show the "Count of Activity" in the heat map so that it looks like this:

Is this possible?

[mhmohammed]

Hi Jay,

In that case, use a Tree Map, instead of Heat Map.

Thanks,
Mahboob Mohammed

[mhmohammed]

Hi Jay,

Before turning the table in the last image into Heat map, delete the 1st and 3rd column and then Turn to Heat Map.

Or, create blank Heat Map and then drag and drop Tarinstrument and Count of Activity on it, nothing else. it doesn't matter what else you have in the report, unless you have a special reason to show them.

Thanks,
Mahboob Mohammed

[former_member680965]

Hi Mahboob,

Getting rid of the 1st column is fine.

But I need the 3rd column.

Thanks,

Jay

[former_member680965]

Hi Mahboob,

The reason why you see the Rectangle Weight as Count([UniqueActivity]) is because of the following:

This was the original table:

The last column UniqueActivity is a variable I created which is stored as a dimension and I simply dragged this into the table.
I then edit it as per below:

I changed the formula to =Count([UniqueActivity])

After editing the formula this is what the table looks like:

I then simply renamed the last column from UniqueActivity to Count of Activity so that the final table looks like this:

So is there any particular reason why I cannot display the Count Of Activity values in my Heat Map?

Thank You,

Jay

[mhmohammed]

Hi Jay,

Why do you have so many dimensions in Rectangle Title? I was expecting to see only the object TAR Tarinstrument and in the Rectangle Weight, I was expecting to see the measure Count of Activity, why do you have =Count(UniqueActivity)?

Thanks,
Mahboob Mohammed

[former_member680965]

Hi Mahboob,

I removed a lot of the dimensions so now it looks like this:

Thanks,

Jay

[mhmohammed]

Hi Jay,

It's a simple update, follow the below steps.

1. Right click on the Chart -> select Format Chart or Format Chart Plot Area (depending on Java Applet mode or HTML mode)
2. Under Global -> click on Data Values -> check the box for Data Label Displaying Mode and click Apply and OK.

Thanks,
Mahboob Mohammed

[former_member680965]

Hi Mahboob,

I am using HTML mode.

I tried your suggestion and unfortunately this did not work.

The Count Of Activity is measure which determines the rectangle weight and my chart is defined like this:

Does this give you any further ideas on how I can get the count displayed in the chart?

Thank You,
Jay