Allow Pivot columns to resize

Comments

12 comments

  • Avatar
    Aviad Harell

    Paul,

     

    Thank you very much for sharing! 

    0
    Comment actions Permalink
  • Avatar
    Paul

    You can also keep the pivot table from spreading across the entire screen by adding the following:

    $('table', args.element).css('width', '');

    0
    Comment actions Permalink
  • Avatar
    Robert

    Hi Paul,

    You can always set selected column to wrap text in BI Studio to avoid truncating data and maintaing a reasonable column width.

    0
    Comment actions Permalink
  • Avatar
    Raghavender

    hi every one I have a requirement where I need to assign a specific color code in Pie chart from a column. Can any one help me...

    0
    Comment actions Permalink
  • Avatar
    Robert

    Hi Raghavender,

    Can you explain what you mean exaclty? If you want to assign a specific color to specific data series, pelase go to Pie Chart properties and in the second tab you can assign colors to selected series (you can also use pick from screen option to assign a specific color from your screen).

     

    0
    Comment actions Permalink
  • Avatar
    Raghavender

    I need the following requirement.

    See the attached screenshot for more clarity

    Graphics Colors consistency: The color of a distributor should be the same in the map, in the graphic. I assigned hexadecimal color codes and provided the in the map (pivot as a column and used the map API for get the colors for the circles) I wand the same color in the pie chart for the same distributor. If a new distributor is added in the data base then the color should auto update in the pie chart. If I use the screen picker this is not possible. If I use the column with colorcodes then that would be easy for color Assignment.

    Let me know if you can help me on this




    Dashboard Requirements.JPG
    0
    Comment actions Permalink
  • Avatar
    Raghavender

    Hi Michal,

    Any luck on the requirement. I have been trying to find all sorts of solutions and your input will be much appreciable.

     

    Raghav

    0
    Comment actions Permalink
  • Avatar
    Robert

    Hi Raghav,

     

    This is beyond my knwoledge unfortunaetly, please issue a ticket to SiSense, I think they should be able to help you with that.

     

    Michal

    0
    Comment actions Permalink
  • Avatar
    Raghavender

    Thanks for at least looking into it and I have raised it to them and they were also of no help except for the suggestion that you gave...

    0
    Comment actions Permalink
  • Avatar
    Aviad Harell

    Hi All,

     

    In our latest version 4.0.xxxx we implemented improved Pivot - now with column resizing

    -1
    Comment actions Permalink
  • Avatar
    Paul

    Allow pivot headers and members to wrap


        $('.pivot-header', args.element).css("white-space","normal");
        $('.pivot-member', args.element).css("white-space","normal");

    0
    Comment actions Permalink
  • Avatar
    Aviad Harell

    Cool stuff Paul. Thanks.

    0
    Comment actions Permalink

Please sign in to leave a comment.