Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I guess this newbee questions was ask a hundered times - but I didn't find something. So the question:
I have a table with saledate, product, amount (per date/product).
I would like to have a linechart, where on the x-axis is the product, on the y-axis is a date vale. In the chart itself is the amount (accumulated for product/date).
Although there's a select box for product and date, the Linecahart should show selected products (or all) and selected date range, so both, x- and y-axis must be dynamic.
Is there some example or tutorial how to create this kind of chart?
Any help will be grateful
Tom
Addition:
I made a picture of what I'm thinking of:
But during outlining this I though this presentation would be to confusing to the viewer. So I guess a grid view will be a good solution.
Hi Tom ,
I dont think so you can do it using Line Chart but you can achieve it using Grid Chart.
Regards,
Chakravarthy.
The Y-axis in the chart you show isn't a product; it's a total amount for a product and month. Other than having labels next to the lines (which isn't supported), that makes it a simple two-dimensional line chart. Dimension 1 = salemonth, dimension 2 = product, expression = sum(amount).