Hi all,
Apologies for the noobness of the questions...but...I have loaded the following sample data. I'd like to use a KPI to show how many of the 5 lines of data are underperforming, on target and over performing
data:
load * Inline [
sample, actual, target
sample1,1,3
sample2,3,3
sample3,4,3
sample4,1,5
sample5,3,3
];
the expression I would use is along the lines of
count(actual<target) for under performing
count(actual=target) for on target
count(actual>target) for over performing
what is the correct syntax for these queries please???
thanks,
Pokes
