Crosstable needed? as headings shown below(Labels) for horizontal Gauge chart

coleturegroup — Wed, 09 Oct 2024 16:57:19 GMT

Hey team, I want to make this gauge chart show something like this:

You notice I'm having an issue with the labels showing over the correct color in the horizontal gauge.

my load script looks something like this:

DataScores:
LOAD
AutoNumberHash128(AppID) as AppKey,
AppName,

Round(Rand()*(10-1)+1) as QualityScore //Create a different QualityScore for each App for testing purposes.
FROM [Some.qvd](qvd)
;

ScoreLimits:
// Data Quality Score: 0 --> 1, 2 --> 4, 5 --> 8, 9 --> 10
left join
LOAD * INLINE [
GoodLimits, CautionLimits, WarningLimits, CriticalLimits
0 , 2, 5, 9
];

The expression in the Gauge KPI Measure is: only(QualityScore)

It was my first thought that a crosstable might do it only haven't been able to get it to work.

Any ideas are appreciated

topic Crosstable needed? as headings shown below(Labels) for horizontal Gauge chart in App Development

Crosstable needed? as headings shown below(Labels) for horizontal Gauge chart