6 Replies Latest reply: Oct 27, 2015 6:16 AM by jagan mohan rao appala RSS

    grouping


      In my dashboard i have three field in drill down Date, hour, minute,. When i have only one date available,in x axis date level wont display it directly goes to hour level. any solution for this?

        • Re: grouping
          Sergey Pokasov

          Hi!

           

          You can change drill down group on cyclic group.

          • Re: grouping
            Aaron Morgan

            That's the default behaviour of a drill down group. Pretty simple solution - don't use a drill down group! You can use a cyclic group if you'd prefer to switch yourself, or you can use a calculated dimension and control when you want the date to switch - this could be done using variables to allow the user to choose or you can code your own logic.

            • Re: grouping
              neetha P

              Hi Nilanjan,

               

              Its as per design,default behavior of drill down group.

              you can control date field, if only one value is present, by adding value or calculated dimension

              as Aaron said.

               

              Regards

              Neetha

              • Re: grouping
                sujeet singh

                Change the group to cyclic one and adjust the field order and sortings.

                • Re: grouping
                  santhosh n

                  Hi,

                   

                  add following expresion in the drill down group,

                   

                  if(GetPossibleCount(Date)=1,hours,Date)

                   

                  BR,

                  SK

                  • Re: grouping
                    jagan mohan rao appala

                    Hi,

                     

                    That is the default behaviour of Drilldown groups, in case if you want to override that try like below

                     

                    Dimensions:

                    Date  , Enable Conditional : =GetSelectedCount(Hour) = 0  AND GetSelectedCount(Minute) = 0

                    Hour, Enable Conditional : =GetSelectedCount(Date) > 0  AND GetSelectedCount(Minute) = 0  AND GetSelectedCount(Hour) = 0

                     

                    Minute, Enable Conditional : =GetSelectedCount(Date) > 0  AND GetSelectedCount(Hour) > 0


                    Hope this helps you.

                    Regards,

                    Jagan.