Parameters passing in urls
AnsweredHi
I am trying to pass a parameter into my url which should be emdeded but the parameter is effected to only some widgets and not to entire dashboard, here i am using 3 different tables and creating a elastic cube. I have tried giving the elastic cube name as table name in url and also the original table names in url but having same issue. Can any one help me on this.
-
Hi Sunil, could you elaborate more on what you're trying to do, and maybe attach some screenshots as well?
For example: are you embedding using iFrame or Sisense.JS, which Sisense view/page are you embedding, what is the parameter passed in via URL (and what is it for?) and what's your end goal? Feel free to go into even more detail than that.
-
Hi Moti Granovsky,
I am using url to just pass parameter with reference to the link https://support.sisense.com/hc/en-us/articles/230651568-Passing-Dashboard-filters-by-URL-Parameters and i am trying to embeded my sisense dashboard into my portal here i have to pass parameters into my dashboard based on the user logged into the portal. For example i am having region level dashboard and one of the person who loggged into portal should access only the particalr region to which he is concerned.
I tried the url concept(passing parametre through url). I have data from 3 different tables which are joined in sisense and created different widgets in same dashbaord the parameter is not effecting all widgets. Elastic cube contains all three tables joined i used the elastic cube as database name and gave region id as parameter. but all the widgets are not working.
-
Hi Sunil,
What happens if you add this filter manually, and not via the URL param?
My immediate suspicion based on your description is that some of the widgets are in "highlight" mode.
To explain: each widget has individual settings for how it handles dashboard filters. For one, each individual dashboard filter can be turned off (by default, when you add a new filter, it will be on). Second, each widget can have all dashboard filters turned off completely. Lastly, each widget can choose a behavior for dashboard filters: "slice" or "highlight".
In "highlight" mode, if the category dimension (usually X axis) is the same as the filter's dimension, all data will be returned, but the selected values will be visually highlighted. In "slice" mode, regardless of which dimension is used, data will be filtered (reduced).
I suggest checking the following:
- Validate again that the schema is correctly composed and that the tables are properly joined.
- Add the filter manually and check if it affects all widgets as desired or not
- Ensure in all widgets that the mode is correct (I'm assuming you want "slice" behavior) and that dashboard filters are turned on
- Ensure there are no errors in the console when passing the URL param
If all the steps above don't help, I suggest contacting your CSM/support to take a look at the issue.
-
Another possibility - if the widgets have their own filter on the same dimension, it has higher priority.
So for example, if in the widget in the picture above there was also a widget-level filter on "Category" dimension, set to "select all", then the widget would display all categories despite the dashboard-level filter limiting to only 2 values:
-
Hi,
I am trying to post dashboard filters via url, though iframe in my app, it is not working but the same generated url is working fine in browser's new tab.
The difference what i can see is in jaql post params in metadata-items-jaql , the table property is not being posted when url invoke from my app.[url formed is correct]
Any idea why this could happen?
Please sign in to leave a comment.
Comments
8 comments