custom sort pivot column
Hi Team,I want to custom sort the Pivot Column.See the screenshot attached.In the screenshot, I want to show particular manufacturer as first entry in the column and likewise.Please share the inputs.Thanks
Forum Posts
Blox - Textblox margin
Hi,I would need you help regarding Blox. I am a beginner in Blox and would need you help creating some title banners for my dashboardI want to use Blox as i want to adjust the height of these banners. {"style": "","script": "","titleStyle": [{"displa...
Conditional CASE Indicator Widget
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 th...
Combine AND and OR in a filter
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
Associate multiple date columns in a fact table to a date dimension table
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...
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...
Download pdf failing with 504 timeout
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.
Add indentation to pivot cell values
Hi Team and @Angelina_QBeeQ I want to add indentation in pivot cell please help:it should be displayed like the below image
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...
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), [Selected Item] = “C” , Sum(A...
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...
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...
