The "Accordion" plugin

Comments

74 comments

  • Avatar
    Aviad Harell

    If anyone is having trouble getting the filters to work, you just need to make sure that dimension text matches the filters exactly.  A quick way to do this is to open up Chrome's javascript console and run the code below.  It will print out the exact dimension text for every filter on your dashboard.

    $.each(prism.activeDashboard.filters.$$items, function() { console.log(this.jaql.dim);})
    

     

     AccordionScript.png

    2
    Comment actions Permalink
  • Avatar
    Joseph Peters

    I've had a hard time getting filters to work but I think I finally have some insight for other users.  As far as I can tell the filters line in the code should actually be a list of filters to exclude from the dashboard.  I was originally under the impression these were filters to include.

    Also you should only have one set of quotation marks in the first set of square brackets.  The example above shows quotes around each filter name but I couldn't get that to work.  

    Here is an example filter line which works for me:

    filters: ['[CN Combined.Segment],[CN Combined.Account Name]'],

    This will make it so the segment and account name filters don't affect the embedded dashboard but the rest of the dashboard filters will still apply.

    2
    Comment actions Permalink
  • Avatar
    Praveena Panigrahy

    Does accordion works for other type of widgets like Pie-Chart /Column/Bar etc apart from Indicator?

    2
    Comment actions Permalink
  • Avatar
    Hila Kantor

    Hi Michal,

    You can change the default height in the main.js file of the plugin:

    1
    Comment actions Permalink
  • Avatar
    Joseph Peters

    Is there a way to change the code to allow this to work with a bar chart?

    1
    Comment actions Permalink
  • Avatar
    Nick Burleigh

    Hi,

    I was wondering why the "Edit Widget" pencil icon gets eliminated from widgets in the accordion. Is there a way to keep that icon there, so that users can go into edit widget mode?

    Thanks!

    Nick

    1
    Comment actions Permalink
  • Avatar
    Mukhsin Fahmi

    Hi @Oxana,

     

    Great to hear that. I will post more, definitely.

     

    Thanks

    1
    Comment actions Permalink
  • Avatar
    Jayesh Vaswani

    I got this issue resolved. I was giving the folder name in the URL once I removed it is working now. 

    1
    Comment actions Permalink
  • Avatar
    Michael Becker

    Hi Malinda,

     

    Accordion loads up widgets when you click on it, it is not a visual trick like Tabber. So in general it saves loading time on larger dashboards.

    Regards,

    Michał

    1
    Comment actions Permalink
  • Avatar
    Oleg Fil

    Hi Kshitiz,

    Does the plugin show up in the list of "plug-ins" in the admin panel? If no please make sure you've put it in the proper folder: C:\Program Files\Sisense\app\plugins. It should appear in the list and should be enabled.

     

    Thanks

    1
    Comment actions Permalink
  • Avatar
    Nicklas Lindgren

    Hello!

    We are using this plugin and it is working great! However we are still seeing the subdashboards in the dashboard grid. They are hidden in the left panel though. I have looked through the code and can only see the logic for hiding the dashboards in the left panel. Is there a fix for this?

    Thanks!

    1
    Comment actions Permalink
  • Avatar
    Joe Keith

    Hi -- The images in the original article are missing.  Is it possible to fix the URL they're pointing to?

    Thanks...

    1
    Comment actions Permalink
  • Avatar
    Anuradha Chatterjee

    Is there a way to get this to work for other widgets like column chart or Tree Map/Scatter Map?

    1
    Comment actions Permalink
  • Avatar
    Hila Kantor

    In order to change the color of the widget:

    1. go to: C:\Program Files\Sisense\PrismWeb\plugins\accordionPlugin\styles
    2. Edit the widget css file:
    3. Replace #187D7B with your desired color
      For example:

      (In the given example I used Notepad ++)
    0
    Comment actions Permalink
  • Avatar
    Stefan

    This plugin is really great!

    Is it possible to have the frame open on the side (Horizontaly) rather than at the bottom?

     

    Thanks!

    0
    Comment actions Permalink
  • Avatar
    Michal

    Hi

    Thanks for the plug in

    is it possible to change the size (height)  of the accordion?

    I tried to change in the css code but couldn't get to the right parameter

    0
    Comment actions Permalink
  • Avatar
    Michael Becker

    Hi,

     

    is there a possibility to skip log in screen within accordion, or maybe I'm doing something wrong?

    Michał

    0
    Comment actions Permalink
  • Avatar
    Takashi Binns

    Hi Michael,

     

    If you are getting a login screen on the accordion, then its probably because the URL you are using to access the top level dashboard is different than the one used for the sub-dashboards.  For example, you might be building it on the local Sisense server and using localhost as your URL but the sub-dashboards are set to something like "dashboard.mycompany.com".  In order for authentication to get passed, you just have to make sure these URLs are the same.

    0
    Comment actions Permalink
  • Avatar
    Michael Becker

    Thanks Takashi, that was exactly the case!

    0
    Comment actions Permalink
  • Avatar
    Stefan

    Is there someone who can help me out with this one: Is it possible to have the i-frame open on the side (Horizontaly) rather than at the bottom (vertically)?

     

    Thanks!

    0
    Comment actions Permalink
  • Avatar
    Eli

    The plugin was updated:

    Sub dashboards that starts with the prefix '_accrd_' will be hidden for none owner users form the dashboards panel.

    0
    Comment actions Permalink
  • Avatar
    Sinu Joseph

    Hiding sub dashboards was an important feature... Thank you Mr. Solution Architect... :)

    0
    Comment actions Permalink
  • Avatar
    Michal

    Hi, I tried to hide the sub dashboards but it didn't work...

    I added the _accrd_to the dashboard name, now it looks like this: _accrd_CA

    but, the users can still see 

    0
    Comment actions Permalink
  • Avatar
    Joseph Peters

    Hi Michal, it may be that you need to replace your old plugin folder with the updated one.  This isn't something built into SiSense itself but rather part of the plug in code.  On a side note, if you already have a name format for your embedded dashboards you can edit the 'main' script to search for any string to hide the dashboards.  For instance, I was using 'EMB ' at the beginning of mine so I changed _accrd_ to 'EMB ' in the file and all my dashboards were hidden without having to change the name of each dashboard.

    0
    Comment actions Permalink
  • Avatar
    Vinod Rajasekaran

    I tried doing this but editing the script opens a blank page with the address base_url/app/scripteditor#/dashboards/551a119110ba3bbc1200023d/widgets/undefined. I see this happens with some other widgets too. Any  ideas if this is related to the plugin or something in my installation ?

    0
    Comment actions Permalink
  • Avatar
    Michael Becker

    Vinod,

    before you can edit script for a widget you must create it and click apply at least once so it is created in SiSense DB, this will allow editing script for that widget.

    0
    Comment actions Permalink
  • Avatar
    Hila Kantor

    Important note:

    Angular routing works with the "#" format for URLs. In Chrome, you can use either "page#/params" format, or "page/#/params" format, but in FF and IE only the second format works.

    So all you need to do, is add that forward slash to the url.

    So, if the accordion's url was "http://10.0.0.5/app/main#/dashboards/5523d58346707c3cb5000014"
    you need to change it to "http://10.0.0.5/app/main/#/dashboards/5523d58346707c3cb5000014"

    0
    Comment actions Permalink
  • Avatar
    Vinod Rajasekaran
    Would the accordion plugin work with the upcoming Text widget in release 5.7 ? This would make for really nice tabbed dashboard views with the sub dashboards hidden from users.
    0
    Comment actions Permalink
  • Avatar
    Michael Becker

    It won't for now since TextBox does not have ability to put JS behind it :(

    0
    Comment actions Permalink
  • Avatar
    clickdashboard

    Hi Hila. Thank you for sharing! I'd like to join Vinod for asking to have TextBox this feature as well. It's reasonable, since the Indicator already has a title which is relevant to it's value (for example: Indicator with title "Total Revenue" shows a number 3.93M). How can you 'hint' to the user, that he need to click on the Indicator? How can you 'hint' to the user,that Accordion dashboard will show "Revenue vs Units Sold" ?

    In addition, I noticed in the figures above, that the filters in "parent dashboard" (years 2012-2013) do not influence the popping up "Accordion dashboard" (show all years from 2010 to 2013). Is it by design? The expected (intuitive) behavior is that the selected filters will populate to the connected Accordions.

    Thank you in advance,

    Pavel from Click

    0
    Comment actions Permalink

Please sign in to leave a comment.