Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
the problem is the products are not same all the time...
Like this
yes but how to do it when i have products that have various name
See Attachment.
You can add some Products in script.
Regards,
Antonio
is there anyway I can show the dates at the bottom like this
Day
Month
year
for example
15
Jun
2015
See attachment