Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
nice one Petter, so simple!
Hi Petter,
Worked perfectly, many thanks.
Pokes