[Solved] Icon sets in result table? Is it possible?
In Excel, you can use Icon sets to create the cells in this image. Is this even possible in Analytica?
How's this look?
Here is the model that produced this:
The main work was obtaining the icon images. I did that as follows. I created 3 constant variables, which I named Icon_for_decrease, Icon_for_increase and Icon_for_no_change. Then I used SnagIt (a program from TechSmith) to copy the image of each arrow from the image you posted (The snip it tool built into Windows would work fine for this as well). When doing the screen grab, I selected a rubber band rectangle around one arrow in your image, and then I clicked in the Definition of one of these constants and selected Paste (Ctrl+V). After repeating that 3 times, I had the three icon images.
Wow. I didn't expect that. Very cool. I like how your arrow shows the day's change while the number shows today's price. Perfect.
I'm sure I'm pressing my luck, but since that was possible, is it possible to put sparklines in result table cells, like this?
I extended the previous example model to get this:
I had to add a time dimension (the index Historic_date), and I simulated some random data over a 14 day period. For the spark line, I did not use a Cell Format Expression -- instead, it is a straight image -- i.e., the result of the computation for the corresponding cell is an image -- the spark line. The expression to compute the sparkline image is just:
where Price is indexed by Stock and Historic_date. Because this is a new variable, I had to repeat the Cell Icon expression for the new variable, and I added an IF so that it placed the icons only in the first column.
Here is the new example model:
Why does the arrow go up for Stock B? From the sparkline, it looks like the price dropped. Shouldn't that be a down arrow?