13 Replies Latest reply on Apr 6, 2018 2:34 PM by laurie mcconville

    FIeld LABEL format

    laurie mcconville

      I have two corner field labels.  I want to show one and not the other, but any formatting I do to one affects both.

       

      Is there a way to choose the formatting of just Course Comparison to either not show, or change to white font so it is invisible?

       

       

       

       

       

      Laurie McConville

      Research Technician III

      Office of Institutional Research

      California State University, Chico

      Chico, California 95929-0850

      (530)898-4736

       

       

        • 1. Re: FIeld LABEL format
          Deepak Rai

          Right Click Course Comparison Pill and Uncheck Show Header.

          • 2. Re: FIeld LABEL format
            Joe Oppelt

            Do you need to show the [Course Comparison] values in the chart?  Is it just the label of the column name you want to mess with?

             

            As you found, changing the label for one changes all of them.  If you want to hide all the values as well as the column label, the Deepak's suggestion is what you need.  But if you want to see the values but not the column header, then you have to hack.  One way is to float an opaque object (such as an empty container colored the same as the rest of the background) over that header on the dashboard.  Another thing I've used is to create a copy of the field and name it ".".  (Just put a period or some other tiny character in the field name.)  It's ALMOST imperceptible.  I haven't been able to figure out how to put some nonprinting character in the field name, but there might even be a way to do that.

            • 3. Re: FIeld LABEL format
              laurie mcconville

              Thank you, however, That hides all the colleges; I only want the field label hidden.  When I right click and choose “hide field labels for rows” it hides the label “course comparison” but it also hides the label “Year”.

               

              Course Category is dimension of dimensions, based on a parameter choice

               

              case

              //when 1 then

              when 2 then //current choice in parameter as shown in first snippet

              when 3 then

              when 4 then

              when 5 then  + " " +

              else "All Courses"

              end

               

              Results of unchecking ‘show header’ for course category; as you can see, the entire column of colleges is gone.

               

               

              Laurie McConville

              Research Technician III

              Office of Institutional Research

              California State University, Chico

              Chico, California 95929-0850

              (530)898-4736

              • 4. Re: FIeld LABEL format
                Deepak Rai

                See what I did. I created a New Dimension and just put a DOT(.) for Name. So when I drag it to Row, I think . is hard to detect.

                Hope it Helps

                Thanks

                Deepak

                 

                • 5. Re: FIeld LABEL format
                  laurie mcconville

                  Thank you.  Regretfully I cannot do that as other users have to be able to edit logically.

                   

                   

                   

                  Laurie McConville

                  Research Technician III

                  Office of Institutional Research

                  California State University, Chico

                  Chico, California 95929-0850

                  (530)898-4736

                  • 6. Re: FIeld LABEL format
                    Deepak Rai

                    You just need to put the name of your Calculated Column in new field and it would Change depending upon parameter and would just Display . for Title Header

                    • 7. Re: FIeld LABEL format
                      Joe Oppelt

                      joe.oppelt wrote:

                       

                      ...One way is to float an opaque object (such as an empty container colored the same as the rest of the background) over that header on the dashboard. ...

                      I'll repeat this part ^^^

                      • 8. Re: FIeld LABEL format
                        laurie mcconville

                        When I go to “format, cell size” it’s grayed out.  And not matter what I do, whether it’s formatting the individual measures or measure names by going to the field, right clicking on the cell, etc, only the header alignment will change, I cannot align the cells.  The data is two measures, depending on the parameter.  And the data cells will not align right.

                         

                         

                         

                        Laurie McConville

                        Research Technician III

                        Office of Institutional Research

                        California State University, Chico

                        Chico, California 95929-0850

                        (530)898-4736

                        • 9. Re: FIeld LABEL format
                          laurie mcconville

                          You are saying to change the name of my calculated field to “.”  Yes?

                          I understand how that works, I’m just saying that we have several editors working on workbooks and using “.” Is likely to cause confusion for other developers and be rejected as a workaround.

                          If it was just for myself I would use this or something similar to this.  Thank you again.

                           

                           

                          Laurie McConville

                          Research Technician III

                          Office of Institutional Research

                          California State University, Chico

                          Chico, California 95929-0850

                          (530)898-4736

                          • 10. Re: FIeld LABEL format
                            Deepak Rai

                            That's fine, But I learnt another trick today

                            • 11. Re: FIeld LABEL format
                              laurie mcconville

                              When I go to “format, cell size” it’s grayed out.  And not matter what I do, whether it’s formatting the individual measures or measure names by going to the field, right clicking on the cell, etc, only the header alignment will change, I cannot align the cells.  The data is two measures, depending on the parameter.  And the data cells will not align right.

                              I cannot use the trick of putting measure names in the rows, because the data cannot display all measures at once.  It is a single measure chosen from a parameter of 7 measures.

                               

                               

                               

                               

                              Laurie McConville

                              Research Technician III

                              Office of Institutional Research

                              California State University, Chico

                              Chico, California 95929-0850

                              (530)898-4736

                              • 12. Re: FIeld LABEL format
                                laurie mcconville

                                The year field to the left of it is expandable (hierarchy) which adds a column for term when expanded.

                                 

                                 

                                Laurie McConville

                                Research Technician III

                                Office of Institutional Research

                                California State University, Chico

                                Chico, California 95929-0850

                                (530)898-4736

                                • 13. Re: FIeld LABEL format
                                  laurie mcconville

                                  My prior email explanation was written incorrectly, so I am restating my issue in this email.

                                   

                                   

                                  When I go to “format, cell size” it’s grayed out.  And no matter what I do, whether it’s formatting the individual measures values, whether I go to the field, right clicking on the cell, etc, or format the measure, I cannot right align the cells.  The data displayed is a single measures, depending on the parameter.  And the data cells will not align right.

                                  I cannot use the trick of putting measure names in the rows and measure values in the text, because the data cannot display all measures at once; i.e. I need it to only display the single measure chosen.  To reiterate, It is a single measure displayed chosen from a parameter of 7 measures.

                                   

                                   

                                  Laurie McConville

                                  Research Technician III

                                  Office of Institutional Research

                                  California State University, Chico

                                  Chico, California 95929-0850

                                  (530)898-4736