Single Value trellis wrap result and font color

[chiennylin]

Hi,

I have a single Value visualization with trellis. The dashboard was created to get the backlog count + how long the backlog is in the system.
on a list view, the result is:

sp_type values(sp_tot)

Post-o.splexcbj-HAPQ	1484 (0min)
Post-o.splexcbj-HUEVQ	32 (0min)

im using:
eval sp_type=sp_qtype."-".sp_qname
stats sum(sp_msgnum) as "total" by sp_type sp_msgbcklog
eval sp_tot=total." (".sp_msgbcklog."min)"
sort total
streamstats count as "AA"
eval sp_type = printf("%*s", len(sp_type) + AA, sp_type)
where total!="0"
stats values(sp_tot) by sp_type

 then i use single value visualization, the display is like this:

but the problem is that i need to make the result is in RED color, and to make sure that the result will not overlap each other like the one in the screenshot. 

*i added streamstats to sort and make sure that the one with highest value will return first

Any idea how to achieve that?  

[kamlesh_vaghela]

@chiennylin 

Can you please share your sample XML and sample data in tabular format?

KV

[chiennylin]

Hi Kv.

on tabular:

Post-o.splexcbj-HAPQ	1484 (0min)
Post-o.splexcbj-HUEVQ	32 (0min)

HTML wise i didn't really change anything. 
i just added:

#prg_spback .facets-container{
display: flex !important;
justify-content: center !important;
}
#prg_spback div.viz-facet{
$tokWidth2$;
}

then its tie to:

<progress>
<condition match="$job.resultCount$==0">
<set token="tokWidth2">width: 0% !important;</set>
</condition>
<condition match="$job.resultCount$==1">
<set token="tokWidth2">width: 95% !important;</set>
</condition>
<condition match="$job.resultCount$==2">
<set token="tokWidth2">width: 45% !important;</set>
</condition>
<condition match="$job.resultCount$==3">
<set token="tokWidth2">width: 30% !important;</set>
</condition>
<condition match="$job.resultCount$==4">
<set token="tokWidth2">width: 22% !important;</set>
</condition>
<condition match="$job.resultCount$==5">
<set token="tokWidth2">width: 18% !important;</set>
</condition>
<condition match="$job.resultCount$==6">
<set token="tokWidth2">width: 10% !important;</set>
</condition>
<condition>
<set token="tokWidth2"></set>
</condition>
</progress>

but it doesn't fix the wrap issue when the result is huge