[Solved] Markers in Dashboard

[cognostechie]

Guys:

Guys:

I have to make a report like this:

ProductsÃ,  Ã,  (^, 1200), (^, 345)

This would be to indicate that the sales for a product went up/down during a certain time period. Is there a way to achieve this?Ã, 

Would really appreciate your help.
Thanks
Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã, 

[cognostechie]

Found the solution.

[BIsrik]

plz share ur solution and update the status of the topic as [solved]

srik

[cognostechie]

Here's the solution:

Made a list report, took out the borders, formatted to look pretty, inserted 'image' as a column, then pointed that image column to read a .gif file which is an arrow and made it a report expression to read an UP arrow if measure is positive (measure is previous column in the list report), DOWN arrow if measure is negative. Those arrows pointing upward/downward (UP/DOWN arrows) are diferent gif files. There are 4 relative time categories as measures and four arrows linked to them.

[fedix]

Sorry cognostechie but I haven't understand how to create this kind of column. Can you re-explain?

Many thanks

[nonooo]

you have to create a dataitem with the expression Current_Year - Previous_Year
sign of this dataitem will show the evolution...

if that works you can edit this dataitem with something like this:

if ((current_yer - prev_year)> 0) then
('../images/uparrow.gif')
else
('../images/downarrow.gif')

and you add a column with an image inside (url of image is of course your new dataitem...)

[fedix]

you have to create a dataitem with the expression Current_Year - Previous_Year
sign of this dataitem will show the evolution...

if that works you can edit this dataitem with something like this:

if ((current_yer - prev_year)> 0) then
('../images/uparrow.gif')
else
('../images/downarrow.gif')

and you add a column with an image inside (url of image is of course your new dataitem...)

many many thanks for the reply.

bye
Federico