Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
I think you will need to add a canonical calendar here in the script and use flags in your expressions:
Hi ,
why don't you try to add multiple dimensions ?
I doubt that will work here, but can be tried
it doesn't work(
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.
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!
[Номер изменения]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