Build Analytics
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Resolved! How to control which Carousel value Blox displays?

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...

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...

Sum of last 3 months data in Pivot

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 ...

Resolved! Sparkline Disappearing in Widget

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...

ChesAsosa by 8 - Cloud Apps
  • 4 replies
  • 0 kudos

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...

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...

ajque by 8 - Cloud Apps
  • 3 replies
  • 0 kudos

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 ...

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...

column order.PNG
Wojtek by 9 - Travel Pro
  • 0 replies
  • 0 kudos

HTTP Error REST_API Jupyter Notebook

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...

mbjamil92 by 7 - Data Storage
  • 1 replies
  • 0 kudos

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

Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?