Is it possible to combine two combo charts as one?

[#1]

Hi,

I have two combo chart items.

Chart A:

Dimension: =IF(FiscalWeekSerial>=$(curFiscalWeekSeq)-4,Dateinsert)

Expression:  Count(DISTINCT {$<DateType={'EnterDate'},FromGent={'0'},Flag={2}>} ID)

ChartB:

Dimension: =IF(FiscalWeekSerial>=$(curFiscalWeekSeq)-4,FiscalWeek)

Expression:  Count(DISTINCT {$<DateType={'EnterDate'},FromGent={'0'},Flag={2}>} ID)

so, the chart A shows Dates on horizotal axis and count of IDs on vertical axis. Chart B shows weeks on horizotal axis and count of IDs on vertical axis.

Now I need to combine the two charts so that the horizontal axis need to show both Weeks and Dates. I,e from 03/02/2014 to 07/02/2014 it should show with week 32.

Is this possible please can anyone let me know.

Thanks.

[#2]

Yes I did what I want to show is now in attached it is showing only dates on horizontal but at the backend it is calculating both week and Dates. please find attached

so, I need both week and date displayed in horizontal axis.

[MK_QSL]

where is the attachment?

can you load your sample file?

[MK_QSL]

Check enclosed file...

[#5]

Thanks. May be it will work only with Month and Year. But it is not with Week and Date

[#6]

Please find attached.

[MK_QSL]

Like this?

[#8]

Perfect you are right. Will I get the same if I use the below ?

Dimension1: =IF(FiscalWeekSerial>=$(curFiscalWeekSeq)-4,Dateinsert)

Dimension2: =IF(FiscalWeekSerial>=$(curFiscalWeekSeq)-4,FiscalWeek)

Expression:  Count(DISTINCT {$<DateType={'EnterDate'},FromGent={'0'},Flag={2}>} ID)

and also one more thing when I am using Expression2: 0 it is showing all bars in one colour but I need different colours based on each week.

[MK_QSL]

After adding 0. the multicolor will not work.

[#10]

Thanks. But with below I cannot able to set as in 2 attached(whihc is with sample data) How can i get this with the below ones?

Dimension1: =IF(FiscalWeekSerial>=$(curFiscalWeekSeq)-4,Dateinsert)

Dimension2: =IF(FiscalWeekSerial>=$(curFiscalWeekSeq)-4,FiscalWeek)

Expression:  Count(DISTINCT {$<DateType={'EnterDate'},FromGent={'0'},Flag={2}>} ID)

[#11]

Any updates whether will it work with above data?