Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Not sure... your have to implement to test it..
Thanks. I tried it and it is showing only DateInsert or only Week by promoting and demoting dimensions. once again thanks for your help and for prompt replies.