Skip to Content
0

Webi Heat Map - Disable separation by CASE

Feb 09 at 06:38 PM

26

avatar image
Former Member

I am an end user of WebI and I have created a heat map of data. The map is separating data based on the case so if my data includes SAN DIEGO with a value of 100 and San Diego with a value of 100 it shows it in two separate boxes. I am looking at how I can have it show them San Diego with a value of 200. Any ideas or am I stuck because of how our data is warehoused.

capture.jpg (37.1 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Koen Hesters Feb 12 at 10:31 AM
0

Hi,

I guess it will be fixed when you turn your values all in to upper cases.

create a variable: with the formula: Upper([dimension you use for heatmap with value San Diego])

Use the new variable in your heat map in stead of that "old" dimension.

Grtz

Koen

Share
10 |10000 characters needed characters left characters exceeded