7 Replies Latest reply: Jun 29, 2016 4:46 AM by Анна Шумская RSS

    Unite two charts

    Анна Шумская

      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!

      Screenshot_3.png

        • Re: Unite two charts
          Sunny Talwar

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

          Canonical Date

            • Re: Unite two charts
              Анна Шумская

              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.

              • Re: Unite two charts
                Анна Шумская

                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!



                • Re: Unite two charts
                  Анна Шумская

                  [Номер изменения]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

                • Re: Unite two charts
                  Alluraiah Allu

                  Hi ,

                   

                  why don't you try  to add multiple dimensions ?