Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I have a combo chart consisting of the following:
1. A drill down group of dimensions: Product and Date
2. Two Expressions; one is a bar chart with a sum(sales) for product dimension, the other is a line chart showing the trend of sum(sales) across dates for the selected product from the first dimension.
How this works is that the first view is of the bar chart showing sales for each product dimension. When the user clicks on any bar (product), it drills down to a line chart showing the sales across months for that particular product. I did this using the conditional clause to display each expression.
Here's the issue though. I set my bar chart to a vertical orientation style. However, once my chart changes to a line chart, it still remains as a vertical orientation style, which won't make sense for a time series. Is there a way to change the orientation of my line chart to a horizontal one, while keeping my bar chart to a vertical one?
Thanks.
Hi,
Do u want like below screen shot ? I am using year and month drilldown and using the combo chart with two expression are same. otherwise can u share the file?
Iyyappan
No. I see that both your line and bar charts are in the same chart. Mine are seperate. Meaning it first displays a bar chart with products dimension, then once you click on any bar, it displays a line chart with date dimensions.
What I want to do is to change the orientation from vertical (bar chart) to horizontal (line chart) once the chart changes.
I can't share the file though due to confidentiality.
Hi,
using the expression in Conditional in Expression properties
=if(GetCurrentField(DrilldownName) = 'Product',1,0)
=if(GetCurrentField(DrilldownName) = 'Date',1,0)
Hope its help
Iyyappan.
Thanks. But that doesn't give me what I want, which is to change the chart orientation once it drills from a bar chart to a line chart.
Hi,
Understood. I think its not possible. We can set only one orientation in style properties.
regards