line chart presentation

[alec1982]

hi all,

I am looking for best practices of how to present a value of an item that has a price changing every day on a line chart.

for example if we have two products( Laptops, PCS) and the prices on both change everyday and we have the historical prices per date..

What is the best way to present the prices per date on aline chart knowing that I want to see both products on the chart?

Thxs,

Alec

[qumniusomnius]

you can make line chart with 2 dimensions, first one is Date, second one Product

in expression just write sum(Price)

it will show separate lines for each product.

If you want to show just specific products you can make line chart with just Date as dimension,

and write multiple expressions like this:

sum({<Product = {'Laptops'} >} Price)

sum({<Product = {'Laptops'} >} Price)

[alec1982]

the problem is the products are not same all the time...

[antoniotiman]

Like this

[alec1982]

yes but how to do it when i have products that have various name

[antoniotiman]

See Attachment.

You can add some Products in script.

Regards,

Antonio

[alec1982]

is there anyway I can show the dates at the bottom like this

Day

Month

year

for example

15

Jun

2015

[antoniotiman]

See attachment