Custom Filters

Comments

54 comments

  • Avatar
    Malinda Jepsen

    Thanks Takashi, that works for me too! On a side note, is there a way to always hide the right hand filter pane (even after they pick something)?  For example, on our home page, I want to have this be the only filter displayed and I don't want the right hand pane to take up real estate.

    Thanks again!

    Malinda

    1
    Comment actions Permalink
  • Avatar
    Todd Nash

    Hi Takashi,

    I love this Plugin.  Unfortunately, I've been receiving a Widget Error (widget type:filterWidget is not registered) while running on version 6.6.1.13002.  Performing an IIS Reset on my server seems to clear the error, but I find myself needing to perform this more and more frequently.  Is there something I should be doing on my end to prevent this error?

    1
    Comment actions Permalink
  • Avatar
    Chris Bridges

    Hey Takashi,

    This is a great widget. First off thank you for taking the time to create this for anyone to use. One addition that would be useful would be to allow multiple selections. For example, if the filter is for employees, it would be useful to be able to select Bob, Dan, and Sue so that you could compare their performance. Just a thought.

    -chris

    0
    Comment actions Permalink
  • Avatar
    Ajith Kumar Anumolu (Edited )

    Hi Takashi Binns,

    This is a very helpful plugin. Thanks for sharing. Supporting Chris Bridges's answer multiple selection of values (typically check boxes) would be much helpful. One more addition by my part is a text input box (Search box) on the top of the list would be great. We are waiting for that, any help is much appreciated. Please leave a comment if you are able to help.

    Thank you,

    Ajith

    0
    Comment actions Permalink
  • Avatar
    brian garson

    Hi Takashi,

    We're having issues running this plugin with Version 6.7.1 is it supported?

     

    thanks

    0
    Comment actions Permalink
  • Avatar
    Takashi Binns

    Hi guys,

    @Malinda - If you share the dashboard with the right filters panel collapsed, then it should show up that way for your end users.  I don't believe theres a way to force it closed with JavaScript

    @Todd - version 6.6 introduced a new plugin framework, so that may have resulted in different behavior from your previous version.  Is there a test machine you can upgrade to 6.7.1 and see if you get the same problem?

    @Chris and Ajith - I hear you that it would be cool to add in multiselect and a searchbox, but its quite a bit of development to build all this.  I'll keep a note of this feature request (you're not the first people to ask) and add it to our backlog.

    @Brian - I've tested this plugin on version 6.7.1 and didn't see any issues.  Can you provide further details on the issue you're seeing?

    0
    Comment actions Permalink
  • Avatar
    Malinda Jepsen

    Thanks Takashi!

    0
    Comment actions Permalink
  • Avatar
    Praveena Panigrahy

    Hi Takashi,

    Is there any way that I can resize the text area of custom filter?

     

    Thanks,

    Praveena

    0
    Comment actions Permalink
  • Avatar
    melanie baji

    Hello Takashi,

     

    does this work in 7.0? it seems that when we update our version (from 6.6 to 7.0), the custom dashboard filter is not doable for 2 different cubes/source.

    0
    Comment actions Permalink
  • I am using the "filter widget" widget

    https://support.sisense.com/hc/en-us/community/posts/221225588-Custom-Filters?flash_digest=f5b35504b8aec5e5d6052125973a491f75aeea59

    I have a problem, because I continuously get the following message

    "widget type: filterWidget is not registered"

    I do not understand what is due.

     

    my version of sisense is 7.0.2.13001


    This is the error,
    appears where the widget should be

    0
    Comment actions Permalink
  • Thank you, he has given me many opportunities.
    my solution has been: enter the administration module (admin), section "system configuration", "plug-ins", disable the plugin "filterwidget" and then re-enable it.

    It has already happened to me several times. So I do not think it's the best solution for me.

    0
    Comment actions Permalink
  • Avatar
    Takashi Binns

    Hi guys,

    @Melanie - I can confirm that the custom filter widget does work w/ version 7, even for multiple data sourced dashboards.  Of course the filters will work the same way as regular dashboard filters, in that filters from EC 1 will only affect widgets that consume data from EC1.  

    @Jose - The behavior you are describing is strange because it seems the plugin is being disabled and you need to re-enable it manually.  Do you know what triggered this change? was it after an upgrade?  In any case, you should be able to add the bold line below to your plugin.json file within the filterWidget folder.  This is basically where the enabled/disabled flag gets stored, when you make the change in your admin panel.  This was new in version 7

    {
    "name": "filterWidget",
    "source": [
    "dropdown.js",
    "stylerController.js",
    "widget.js"
    ],
    "style": [
    "widget.css"
    ],
    "lastUpdate": "2018-04-13T22:20:42.744Z",
    "folderName": "filterWidget",
    "isEnabled": true,
    "version": "0"
    }
    0
    Comment actions Permalink
  • Avatar
    Takashi Binns

    Hi Praveena,

    If you open up your sisense.css file, you should see an entry for .filter-widget-wrapper class at the top.  Here the width is set to 200px, but you can adjust it to fit whatever size you like.

    -Takashi

    0
    Comment actions Permalink
  • Thanks Takashi Binns

    "The behavior you are describing is strange because it seems the plugin is being disabled and you need to re-enable it manually."

    No, I'm sorry, I've explained badly.
    The plugin is NOT disabled alone.
    When the error occurs, I manually disable it, and manually enable it.


     "Do you know what triggered this change? was it after an upgrade? 
    The error started, some weeks after upgrading to V7.


    "In any case, you should be able to add the bold line below to your plugin.json file within the filterWidget folder.  This is basically where the enabled/disabled flag gets stored, when you make the change in your admin panel.  This was new in version 7"
    I opened the file plugin.json and the line inside the file, already appears enable


    Today the error remains, although I enable and disable the plugin.
    The error disappeared when I left the board, closed my session and went back inside.

    it's strange.
    If it happens again, I'll comment again.


    0
    Comment actions Permalink
  • Avatar
    Administrator Intellitix

    Hey Takashi Binns

    Wondering if its possible with this to scan the number of values in the filter and toggle enabling and disabling the dropdown functionality and clear selection option.

    What I am hoping to do is be able to use the same filter on a dashboard and dynamically adjust the UX based on the user logged in. Based on data security and permissions there are some cases where a user will only see 1 value. Currently using the plugin the dropdown menu will still function. Ideally, I would like the single value allocated to that user to instead be displayed and the dropdown disabled. Other users that have 2 or more value options would still function as is with the current plugin.

    Any thoughts?

    Thanks

    0
    Comment actions Permalink
  • Avatar
    Cathy Stevens

    Thank you for the code.  I was able to get it installed.  I can't seem to resize the widget.  Would it be possible to provide some direction?

    I need about five filters at the top of the dashboard. 

     

    Thanks for your help,

    Cathy

    0
    Comment actions Permalink
  • Avatar
    Wes Swanson

    We upgraded to 7.2 yesterday, and the filter widget is completely broken. I've added the missing code to the plugin.json file, stopped and restarted the site, and it's still not working. We use this filter on probably 90% of our dashboards.

     

    SyntaxEditor Code Snippet

     "isEnabled": true,
     "version": "0"
    

     

    0
    Comment actions Permalink
  • Avatar
    Tripti Jaiswal

    Custom Filter plugin is not working in Version: 7.3.0

     

    Regards

    Tripti

    1
    Comment actions Permalink
  • Avatar
    Stefan Castino

    Appears to be inop for IE in 7.3. FF, Vivaldi, and Chrome work fine.

    0
    Comment actions Permalink
  • Avatar
    David Rogers

    I can't figure out how to make the Sort option work.  The filter is displaying a "Reporting Date" character field.  This field contains the dates of the past 35 days, except for yesterday, in which the date value is replaced with the literal word 'Yesterday'  We do this so that Yesterday is always the default selection, and in our underlying data the date that is replaced with Yesterday changes daily.  This provides our users with an updated dashboard daily while giving them the ability to look back at previous days.  Since this is a character field, it doesn't sort how I want it to.I would want Yesterday to be first, and then all of the other 34 dates in reverse order (most recent first).  We can't use Sisense's date TimeFrames because they don't align to our fiscal calendar.

    I have another measure which is in the same table / rows as the fields providing the Reporting Date values.  These are numeric Date IDs (e.g. 20190509 for 5/9/2019).  I would like to use this field to drive the sort.  However, when I try to add this DateID field to the sort, it wants me to do an aggregate (count, max, etc.), and I don't get the desired result.

    Help, please.

    0
    Comment actions Permalink
  • Avatar
    An Y

    We have a dashboard with 5 'Custom Filters' .All of them have the 'no selection' option. We make sure to apply the same 5 filters as the dashboard  filters so that we can enable/disable them on other widgets  however  it makes sense logically.  When we jump on this dashboard from another dashboard we are only passing 1 custom filter's value so only that filters is displayed  in the dashboard filter try rest  of them disappear. The problem is when I  selection something from one of the remaining 4 Custom Filters then it get added to the dashboard filter tray with 'No Selection' in the tittle , and if I select something from the remaining 3 filter now then they add with  their table.column name in the title . Any suggestions on how to work around it ?

     

     

    0
    Comment actions Permalink
  • Avatar
    Tom Lebovic

    Is this supported on v8 of Sisense?

    Thanks,

    Tom

     

    0
    Comment actions Permalink
  • Avatar
    Markus Proctor

    This plugin is promising, but it doesn't work as intuitively as we'd like. Also, there are no styling options to make it look more natural with native widgets.

     

    When you click the dropdown to reveal the options, the "modal" sometimes is above or behind other widgets. When it does pop-up like it should, clicking outside of the menu doesn't close it like a normal <select></select> element. You have to click the widget itself to toggle the modal.

    Can you make these updates, please? :)

    0
    Comment actions Permalink
  • Avatar
    Ashley Plaza

    Is there a script I can apply to change the background color and text colors for these?

    0
    Comment actions Permalink

Please sign in to leave a comment.