CDavidOrr
Cloud Apps
Joined 5 years ago
User Profile
User Widgets
Contributions
Accessing Color Palette from Script
Does anyone know if you can access the color pallet that a dashboard is using from a widget's script? I am adding some color to some of the cells in a pivot. I'd like to use the first color in the current color palette so that if the color palette changes, this pivot will change also. I currently have the color hard coded but would like to make it dynamic. Thanks.Solved2.6KViews0likes2CommentsDashboard filter not affecting Table type widget
I need some assistance here. I know I am missing some small obvious thing but can't for the life of me see it. I have a table in my cube that is an MS SQL data table. I have a custom query to select this data that returns 5 columns, 3 alpha, 1 date (not datetime), and 1 numeric (0 or 1). This table has no associations to any other table in the cube. I created a new dashboard then created a new widget on that dashboard. The widget is a Table widget that displays these 5 columns from the table in the cube. So far, so good. The widget displays all of the rows from the table. Next I added a dashboard filter on the numeric column. The filter "List" correctly shows that there are only two values; 0 and 1. On the widget, the dashboard filters are turned on. However, when I change the dashboard filter to only show rows with a 1 in the numeric column, the widget thinks (... wait cursor) and then displays all rows in the table. It does not filter out the rows with a 0 in the numeric column. I have tried with a filter on the Date column as well as a filter on one of the alpha columns. They all behave the same. All rows are shown regardless of the value of the filters. I have verified that the columns the filters are pointed to are the same columns being displayed in the widget. I tried putting the filters on the widget rather than the dashboard to no avail. I do have row level security set up on the Data cube but this particular table isn't tied into that at all. If that was a problem I would expect that no rows would be returned but, as it is, all rows are being returned. Like I said, I know I am just missing something obvious but am not seeing what it is. This seems like such a trivial task. Any ideas would be greatly appreciated.2.5KViews0likes2CommentsUsing Coalesce with Lookup in a custom column
I need to create a custom column on one of my tables. This column will be a LOOKUP from another table. However, if the current row has no match in the remote table, I want to use the value from the current match column. Here is what I am attempting to use: COALESCE(Lookup([AccMapping], [AccessorialName], [EdiCode], [Code]), [EdiCode]) So if the Lookup returns a NULL, I want EdiCode to be used. However, this is generating a parsing error "Unhandled case label: LookupRemoteTableExpression". I would appreciate any suggestions on how to accomplish this.Solved3.8KViews0likes3CommentsRe: Date filter not working when specifying Months
Of course. This is a pivot table widget and the date field is one of the Row entries. The type on this entry is Months. There is no formula for it. I am just including the date field from one of my Fact tables. I then have a dashboard filter on that same column. Here is some more interesting information. I also have a Chart widget that contains this same date field as a Category. It also does not filter correctly when I select Months. I tried going to my pivot widget and disabling the dashboard date filter and adding that same filter directly to the widget. When I did that, it works fine. So it seems to be something in the interaction of the dashboard filter with the widgets.4.1KViews0likes0CommentsDate filter not working when specifying Months
I have a widget that is filtered by a date field. When I set this filter, using "Calendar", it works fine. When I set the filter using "Time Frame" and selecting any option under Years, it works fine. Selecting any option under Quarters, it works fine. However, when selecting any option under Months, it doesn't filter anything. It is as if the filter is turned off. I am looking for any suggestions that may help me troubleshoot this. I'm sure it must be something in my specific configuration that is causing this but I don't really know where to look to see what may be going wrong. I am currently on a standalone Windows version 20.21.4.10058.Solved4.1KViews0likes4CommentsRe: Horizontal Scroll missing from Dashboard with one Table widget
Katie, I do not get the horizontal scroll when hovering over the table. However, I am on Windows 20.22.4 so from your comments it looks like this is an issue that has already been addressed. We are planning on migrating to a Linux solution soon so I will expect that this issue will go away. Thanks again, David3.3KViews0likes0Comments