mirzay
Cloud Apps
Joined 4 years ago
User Profile
User Widgets
Contributions
widget filters reset to "Include All" when a few users logon, for others, it stays the default value
Has anyone come across a scenario where we set a widget filter to be a particular value and publish the dashboard. However, when another user sees the dashboard, the widget filter changes to "Include All" It is the same dashboard id. What am I missing as I thought widget filters stick to what they are set?1.8KViews0likes2CommentsRe: Dashboard Filter Date in Last 180 days or NULL?
I am using your filter formula to filter for a date that is Null or the date occurred in the last year. The result is picking up all years and also the null value. How can I restrict to filter to last year and null values? { "or": [ { "last": { "count": 1, "offset": 1 }, "custom": true }, { "include": { "members": [ null ] } } ] }3KViews0likes0CommentsPie Chart, select 1 particular slice and rest are "Others"
Is there a way to select 1 particular slice of a pie chart and move the rest to "Others". By choosing the Select 1 slice option, it picks up the highest value and moves the rest to others. I want to be able to pick another category of the slice.Solved3.1KViews0likes3CommentsDebugging: function date_part(unknown, integer) does not exist
When creating a formula in Pivot to get number of days between two date fields, using the DDIFF() function, I get the following message when the widget errors out. function date_part(unknown, integer) does not exist Note, these are date only fields and not timestamp/datetime. I filtered out Null values using the widget filter and even tried filtering out in the Formula date fields. Live connection to a PostgreSQL database. Update: The formula works if one of the 2 days is a timestamp field. 2 date only fields error out. This seems to be a bug in the function.2.7KViews0likes0CommentsReport Manager - Custom Templates
The premium Report Manager plug-in has very limited documentation on using Templates. There is a "out-of-the-box look and feel feature" mentioned. Q1) Is this the API Report Manager Template? Q2) Report Manager allows multiple templates to be created. A default template is assigned in the settings. There is no mention of choosing any of the other templates when sharing. How can we accomplish this? Q3) Sending reports to non-sisense users, this was picked from the manual: "...the dashboard to export should be shared with the non-Sisense user configured in the Configuration Manager page.". Does this mean every non-sisense user needs to be identified in the configuration? This takes away the flexibility from designers to take ownership to share with non-sisense users.2.5KViews0likes2CommentsRe: Dashboard Filter Date in Last 180 days or NULL?
Thank you for the response Priyanka. I am not getting the expected result. (Converted to Months instead of days but tried both ways) I am expecting the range to be last 6 months to end of next month. What I get are these dates.3.1KViews0likes1CommentDashboard Filter Date in Last 180 days or NULL?
I need to create a dashboard filter that will filter the Closed Date In Last 180 days OR if Closed Date is NULL Would you know how to include the OR Condition in a Dashboard Filter? I tried using the Advanced formula below and some variations of this but getting the Invalid Syntax or Invalid Query messages: { "explicit": true, "multiSelection": true, "members": [ "N\\A", { "last": { "count": 180, "offset": 0 } } ] }3.1KViews0likes5Comments