Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
all,
I am building a line chart. X axis is Quarter and Y is Revenue (bar chart) and growth (line chart).
why is it so ?
Thanks
Ce message a été modifié par : cl bld
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
Go on the General tab and choose the Combo Chart(third option).
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
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.
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
USE COMBO Chart, as this chart type facilitates the combination of Bar and Line chart.
Regards
Nitin
Hi,
Select Combo chart and you can enable both bar and line for your expressions.
Regards,
Raghav
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
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.