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

Forum Posts

Pivot table grand total aggregation not working in line chart

Hi Team,I have calculated the manufacture share on pivot table at two levels ( Retailer and Category) using the formula:dupcount([custom manufacturer_sort])/(dupcount([custom manufacturer_sort]),all([custom manufacturer_sort]))Now, the default grand ...

zohebakber_3-1690534935918.png zohebakber_0-1690534697952.png zohebakber_1-1690534744674.png

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

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

To avoid duplicate exported data

Hi Team,Iam trying to find a solution, we have a dashabord with pivot widget and a blox button to export the widget to xml.We have a requirement, where we should hide/not to display already downloaded rows, each row will have a uiqueid.Please suggest...

Live Model slow despite filtering

SUMMARY:My Live Model is slow. Source data is big, but a dashboard filter picks just one item, so I think it can be fast. This feels like a common use case for a Live Model.DETAIL:My dashboard is based on a live model that queries SQL Server. The use...

Tim by 10 - ETL
  • 0 replies
  • 1 kudos

How to create a new column with percentiles?

In Sisense, I'm looking for a way to create a new column in a table, with percentile values of a different column.I am open to design suggestions/approach. What the best way to accomplish this.Such that: 1. Have a filter created on percentile values ...

leo82 by 9 - Travel Pro
  • 1 replies
  • 0 kudos

Error: "Live models can have only one dataset"

I clicked "Duplicate As Live". I got an error "Live models can have only one dataset".I made sure I only have one dataset (see left side of picture below). So why am I getting the error?I did refresh schema on all tables, and made sure they all point...

Tim by 10 - ETL
  • 3 replies
  • 0 kudos

Re-Order Pivot table Items

Hi, I have a pivot table where there are various areas listed 1-15 but it will order it by the first number in the series ie. 1, 10, 11, 2 , 3Is there a way around this so it will read 1, 2 , 3... 10 , 11

Juandres by 8 - Cloud Apps
  • 0 replies
  • 0 kudos

Rank based on each month

Hi @Angelina_QBeeQ ,I want to set the rank independently for each month based on measure.Rank logic: RANK([Overall Vol],"1224",[l3_demand],[Months in contact_date])As per below sc, rank shd be 1,2,3....for Mar and similarly 1,2,3...for Feb and so on....

tsaho8 by 7 - Data Storage
  • 4 replies
  • 0 kudos