Spotfire String Value on Y Axis of KPI
Hi All,
Got another KPI Question here.
I was playing around with the Y axis value on the KPI chart of Spotfire and I noticed that it seems as if you cannot put a string value on this field.
Is this correct? Can someone confirm?
I'm new to spotfire and I just want to make sure that I am not doing something incorrectly.
Thanks!
-Missy
Aug 03, 2017 - 1:55pm
Buffzilla
+ Add a Comment
(1) Answer
Hello,
The Y-axis is the Value axis and is meant to be used with aggregeate expressions like sum(sales),avg(price) etc. The string values cannot be used on the Y-axis even for any other visualizations as well. If you try to use String values those would need to use an aggregate function like UniqueCount or CountBig.
Aug 03, 2017 - 11:43pm
Sayali Patil