Our team recently decided to adopt Toad for Data Analysts to manage some clinical trials data. One more complex Excel report needs to have a red, yellow, or green circle in the rows of one column (“Column B”). The color of the circle is dependent upon the data in another column in the report (“Column A”), such that if the value of Column A for a given row is 0-0.25 that row’s Column B would have a green circle, if Column A is 0.25-0.5 Column B would have a yellow circle, and so forth.
I’ve seen what appears to be functions that would allow me to implement this data-driven image/shape placement in an Excel report, but I haven’t been able to figure out how to piece these functions together correctly.
Does TDA support this conditional image/shape insertion and if so what are the steps to set this up?
If each time this report is generated, the query will need to pull out a different set of clinical trials, would it be smarter to save this query with variables?
My apologies if this questions was posed in a previous thread; I was not able to use the right search terms to find it.