Resolved! error posting message on community
This is error im getting when trying to pick customer service analytics label
Forum Posts
Referencing Filter Value in a Sisense Formula for Dynamic Data Display
I’m trying to switch the displayed data based on a user selected filter.This would be done in Power BI using something like the below:Value = SWITCH(TRUE(), [Selected Item] = “A” , Sum(A), [Selected Item] = “B” , Sum(B), ...
Hive query showing error in Sisense
Hi Team,Built query in Hive. It's retrieving results in Hive terminal,But when i try to parse the same query in Sisense through elastic cube .giving me the following error:cannot POST /api/v1/connection/cf8a8ccb-6080-4067-a6e7-8a792a127581/table_sche...
Error when using DDiff function
I am trying to add a column to my report using the DDiff formula but getting the following error (also attached): Error querying your data modelBE#208517 Internal Analytical Engine Error: org.antlr.v4.runtime.misc.ParseCancellationException My fromul...
Resolved! Wiser Filter Widget
Has anyone been able to use the wiser filter widget? we recently installed the Wiser filter widget plugin, but it has not been working. The filter does show up in the list of add ons when on the Admin tab in the UI. We are able to enable/disable the...
Pivot Table - Value from past date
Hi Team,I have a pivot table where I have different dates and number of cities. In the other column, I want no. of cities from last date.The PREV function or DIFFPASTDAY Function is not working as dates are not in any pattern.So, in the screenshot be...
Resolved! Hyperlink KPI Widget
Hello Experts! Client requested to have the KPI widgets (Indicator) contain hyperlinks that would direct them to another dashboard or site link once clicked. Is that possible? Hoping someone can help me with this ask. Any tips will do!Thank you in ad...
Resolved! Dashboard filter still affects widget after deletion
I have deleted a blox dashboard filter but it still show and is still affecting widgets on the dashboard. None of the below dashboard filters are actually on the dashboard anymore. I have deleted them and want to create a new one but these old ones a...
Set marker symbol for each category in line chart
Different marker symbols can be set to line chart based on its value (Y-axis) using this script. But in some cases we may need to set icons for each category (X-axis), Here is a script to achieve this https://www.binextlevel.com/post/set-marker-symbo...
filter options displays not in ascending order, Ages <16 displays at the end of the list
Hi All, I am wondering if there is any possibility to sort the list in the filter. the values are shown by default in assending order but if one of the value has a special charater like greater than, can we bring it on top of the list. Please let me...
Resolved! How to model changing Membership Types when calculating Historical Data
I have a user table with a property MembershipType. I also have a second table with documentations that our staff are filling for each user over time The common key here is "username". I need to create a breakdown of # of documents filled per members...
change order of column aggregation in pivot
Im looking for way of changing order in which column are aggregated in pivot table.Below you will currently what I have. I have month numbers first and for each month I have Primary and Comparison Value.What client is looking for is to have Primary V...
Summarise Dashboard Filter Date selection as a widget on the Dashboard
Using Dashboard Filters, I can select a date range that affects multiple widgets on my Dashboard. If the Filters pane is collapsed, users have no way of referencing what date range is currently applied. Is there a way to summarise the date range sele...
Refresh Elastic Cube Programmatically
After elastic cube built, I need to refresh the cubes based on the flag exists in Database.I created and build the elastic cube and now I want to refresh this cubes , if column value in give database in Y. instead of defining the interval
Editing BloX "protected template"
Hi, I'm working on a prototype in Amex's E1 environment and I cannot save changes to the BloX widget. I get a dialog box stating that changes can't be saved because the template is protected. I was able to save yesterday and I don't recall protecting...
