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

Forum Posts

Want to check column datatype and convert accordingly

Hi ,Am building one dashboard where my one of the column and it's data type is String and it will have both alpha numeric values ,numeric and string values. I want to check if it numeric then i need to replace it with 0 and if it string need to displ...

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
  • 2558 Views
  • 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...

zohebakber_0-1688386032681.png

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
  • 611 Views
  • 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
  • 139 Views
  • 0 replies
  • 0 kudos
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?

Email community@sisense.com