Line Chart no bar option for expression

[#1]

all,

I am building a line chart. X axis is Quarter and Y is Revenue (bar chart) and growth (line chart).

• I chosed the line chart. I have one dimension Quarter, and two expressions. I would like sum(Revenue) be in bars. but the option 'bar' in tab Display Option is grayed...

why is it so ?

• I want to display revenues for Q1 2012, Q2 2012, Q3 2012, Q4 2012, Q1 2013 etc... quarters and years are two separate dimensions. if i set year and quarters as 2 dimensions for the chart, it is displaying four line charts and X axis are years. how can i build this line chart ?

Thanks

Ce message a été modifié par : cl bld

[iktrayanov]

Go on the General tab and choose the Combo Chart(third option).

[MK_QSL · Accepted solution]

Select COMBO Chart,

DImension :

Quarter-Year

Expessions:

1) SUM(Revenue) - Select Bar and Untick Line option

2) SUM(Growth) or whatever your dimension - Select Line and untick Bar option

[jagan]

Hi,

Instead of Bar Chart select Combo Chart, if you dont have Quarter-Year dimension arrive it in script like

LOAD

*,

'Q' & Ceil(Month(DateDimensionName)) & '-' & Year(DateDimensionName) AS Quarter-Year

FROM DataSource;

take Dimension as Quarter-Year and use the following expressions

Sum(Revenue) - Select Bar

Sum(Growth) - Select Line option and uncheck Bar option

Hope this helps you.

Regards,

Jagan.

[suresh_rawat]

Hi Oilandgas,

If you want one expression shows in bar chart and one in line chart.

Then you have to use Combo chart for such representation.

Please refer the attached image.

Hope this will work out for you.

Regards

Suresh Rawat

[Anonymous]

USE COMBO Chart, as this chart type facilitates the combination of Bar and Line chart.

Regards

Nitin

[raghavsurya]

Hi,

Select Combo chart and you can enable both bar and line for your expressions.

Regards,

Raghav

[#8]

Thanks.

i have already a variable 'Quarter' and a variable 'Year'

can i build in the Combo Chart wizard directly the Quarter-Year variable ? how to ?

Thanks

[jagan]

Hi,

I am not talking about variable, create additional dimension in script for Quarter-Year and use this expressions.  If possible can you attach the sample file.

Regards,

Jagan.