Unite two charts

[#1]

Hi!

I need to unite two charts into one, so that two columns will be next to each other by month.

Data for 1st graph: DATE(MONTHSTART([ZSLM_E020_MNDTM.Принято на поддержку]), 'MMM')

Measure:Count([Номер изменения])

Data for 2nd graph: DATE(MONTHSTART([ZSLM_E020_MNDTM.Регистрация завершена]), 'MMM')

Measure:Count([Номер изменения])

I don't understand how to write one function date(monthstart()) for two fields.

Thank you for your help!

[sunny_talwar]

I think you will need to add a canonical calendar here in the script and use flags in your expressions:

Canonical Date

[Anonymous]

Hi ,

why don't you try  to add multiple dimensions ?

[sunny_talwar]

I doubt that will work here, but can be tried

[#5]

it doesn't work(

[#6]

Hello!

The result there- is what I exactly need.

I still don't understand how to write script in my situatiaon, because i have all my data in one table, but i will try one more time tommorow.

[#7]

Hi!

So I just need to unite in DataBridge 3 fields.

[ZSLM_E020_MNDTM.Регистрация завершена] and [ZSLM_E020_MNDTM.Принято на поддержку] : fields with dates, months, years

[Номер изменения] - this field i need to count

But do i need to create a new table, if all this fiels are in one table right now?

Load [ZSLM_E020_MNDTM.Регистрация завершена], [ZSLM_E020_MNDTM.Принято на поддержку] as CannonicalDate

And what is about DataType?

Thanks!

[#8]

[Номер изменения]2[ZSLM_E020_MNDTM.Принято на поддержку]:

Mapping Load distinct [Номер изменения],[ZSLM_E020_MNDTM.Принято на поддержку] Resident [ZSLM_E022_MNDTM] ;

[Номер изменения]2[ZSLM_E020_MNDTM.Принято на поддержку]:

Mapping Load distinct [Номер изменения],[ZSLM_E020_MNDTM.Регистрация завершена] Resident [ZSLM_E022_MNDTM] ;

[DataBridge]:

Load [Номер изменения], ApplyMap('[Номер изменения]2[ZSLM_E020_MNDTM.Принято на поддержку]',[Номер изменения],Null()) as Cannoncaldate, 'Реализовано' as DataType

Resident [ZSLM_E022_MNDTM];

Load [Номер изменения], ApplyMap('[Номер изменения]2[ZSLM_E020_MNDTM.Регистрация завершена]',[Номер изменения],Null()) as Cannoncaldate, 'Зарегистрировано' as DataType

Resident [ZSLM_E022_MNDTM];

this doesn't work