Gramsey
Cloud Apps
Joined 4 years ago
User Profile
User Widgets
Contributions
Re: Is there a way to iterate or break an entire widget by a dimension field?
While not the exact solution we adopted -we used a double axis chart - with a global filter for one of the dimension fields. The switchable dimension filter would've worked but we decided on adopting the other option1.7KViews0likes1CommentIs there a way to iterate or break an entire widget by a dimension field?
USE CASE: I have a dimension field - let's call it state that has 50 possible values but these change based on the data range selected. I'd like a bar chart with 2 columns # of Yes's and # of No's to break by each state into its own widget instead of the same widget and axis. So if I have only 3 states present for one date range the output would be 3 different widgets filtered (or the appearance of) for the available states. Is there a way in sisense to make this happen? Is this possible in blox? I've considered creating a bar chart for each possible dimension value then hiding/displaying based on data but that seems terribly inefficient. Any help would be appreciated.Solved1.8KViews0likes6CommentsRe: Deselect stacked Column chart legend value by default
harikm007 - Yes this is exactly what I was looking for. I've hit a small snag though as the widget is scaling the report accounting for all values including those deselected by default in scaling the vertical axis - so to apply my case to your example - Midwest is 10m so the vertical Axis scales up to 12M - even though that value isn't displayed and it makes the values in the chart look small. I tried changing the event and forcing a refresh but couldn't find away around it, any suggestions on how to address the scaling?4.6KViews0likes0CommentsRe: Deselect stacked Column chart legend value by default
Thank you for the replies but I'm actually trying to leave the filtering out of the dashboard filters entirely and only deselect the value from the widget legend (widget affects dashboard filters is disabled for this widget) by default. Creating a dashboard filter that only filters on this widget isn't an option either. So really Im only interesting in affecting the widget legend and native filtering abilities4.6KViews0likes0CommentsDeselect stacked Column chart legend value by default
Hi, I'm looking for help deselecting a stacked Column chart value by default. Use case: I have a stacked column chart stacking a metric (# of Actions suggested) by date. Lets say I have 4 actions: Run, Hide, Fight, and No Action - over 90% of my data is "No Action" I'd like to deselect the "No Action" value in the legend of the widget by default each time a user accesses the dashboard to highlight the more actionable data - but still have the value be available if users elect to view it. I'm a novice at manipulating the widgets via script and haven't found any similar scripts to give me a starting point on this, so any help would be greatly appreciated.4.7KViews1like5Comments