I've been playing around with Blox indicators and sparklines for a while now, and I have a fantastic-looking dashboard. But...I want my widget to adjust its indicator value based on the dashboard 'time period' filter. This can be changed from days to...
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...
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), [Selected Item] = “C” , Sum(A...
Hi, We need to fetch some accounts that have not made any purchases in the last 3 months. In SSMS I use below code, but this seems to be not working correctly when I use it in the cube (as table query). SUM(Amount) OVER (order by Date ROWS BETWEEN 3 ...
Good morning,I am new to Sparklines in Blox and running into an issue where some of my sparklines will show data but will not scale so that you can see the trend line on the indicator. I have attached a screenshot of two cards created using a templat...
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...
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...
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...
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 ...
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...
This is error im getting when trying to pick customer service analytics label
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...
Hi, I am using REST_API from the custom code section and want to query my elasticube but i am getting a below error:{'error': {'status': 401, 'httpMessage': 'Unauthorized'}}I am using the below query:logical_sql_res = sisense_conn.get_logical_sql(que...
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...
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
