Can we use only static values or is it possible to use dynamic values from a radar search?

[jip31]

Hi!

Concerning the chart radar, I would like to know if we have to use only static values like below or if it is possible to use dynamic values from a search?

| makeresults 
| eval key="current", "Business Value"=.37, Enablement=8.64, Foundations=2.56, Governance=1.68, "Operational Excellence"=4.992, "Community"=9.66 
| untable key,"axis","value" 
| eval keyColor="magenta"

If we can use only static values, how to combine many different key?

thanks

[PickleRick · Accepted solution]

See the example given with the app

| makeresults 
| eval key="current", "Business Value"=.37, Enablement=8.64, Foundations=2.56, Governance=1.68, "Operational Excellence"=4.992, "Community"=9.66 
| untable key,"axis","value" 
| eval keyColor="magenta"| append
    [| makeresults
    | eval key="better", "Business Value"=9.37, Enablement=2.64, Foundations=4.56, Governance=6.68, "Operational Excellence"=9.992, "Community"=9.66 
    | untable key,"axis","value" 
    | eval keyColor="#33FF55"
        ]

 You have two different keys with two different keyColor values. The limitation is that single key has to have one keyColor value.

[jip31]

Perfect, I didn't thought to use append.... thanks

[jip31]

is anybody can't help please?

[ITWhisperer]

What have you tried?