I'm attempting to create an indicator widget that calculates the total number of overdue tickets. It would use two formulas to determine the difference between the total due date day allotment(Ticket must be completed in 30 days as an example) and t...
Hi We need to perform a filter based on dimension values, according to AND and OR logic like (field starts with 1 OR field starts with 2) AND field does not contain 4 Is there a way to perform it? We tried by JAQL but It does not work. Best
For the problem of needing to associate multiple date columns in a fact table to a date dimension table, I have always taken the approach of aliasing the date column in the dimension table with a new column having a descriptive column name for associ...
When creating a bar chart you'd sometimes want to rename the categories/break-by fields Modify the "Break-By" Category Names Apply the following widget script: widget.on('processresult', function(widget,result) { // Translation Dictionary let dict ...
We have a chart showing 5K items and when we click on download pdf, we see a failure with 504 timeout.Please help debug and fix.
Scenario: My organization has ACCOUNT that have multiple balances associated with them, and each account has a TYPE These accounts tie into a PORTFOLIO We have a Pivot that is to return all PORTFOLIOS and the SUMs of these ACCOUNTS. But we would lik...
How can one add a column filter to a widget or dashboard that is relative to an input parameter or variable?
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 ...
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 dis...
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'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 and @Angelina_QBeeQ I want to add indentation in pivot cell please help:it should be displayed like the below image
This is error im getting when trying to pick customer service analytics label
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), ...
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...
