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?
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