vatojavier
Cloud Apps
Joined 2 years ago
User Profile
User Widgets
Contributions
Sisense Intelligence token estimation
Hi. We are considering activating Sisense intelligence to use a LLM for our data models and dashboards. We want to estimate how much this would our organization from the LLM provider side. It depends on the tokens that are input into the model. In the Sisense documentation it mentions that depends on the number of tables and column of the model, but I guess also on the pre-instructions text that is sent along the user's input. Is there a way of knowing how many tokens are added, or how much would cost to create a medium size dashboard given the OpenAI pricing? Thanks, Javi.Re: Can't add table to an already created data source
We need to reselect constantly the database in order to add new tables, why is this happening? There are no error messages whatsoever. Also, why when selecting a new table from the panel we can only select them from the same dataset as the original tables, but when getting a table using a query we can select any dataset we want? What if I want to have a data model from two different datasets?1.5KViews0likes1CommentCan't add table to an already created data source
Suddenly I can't add tables to some data sources, I am an admin of the project and when I try to add a new table either by sql or directly selecting the table nothing happens. No errors message, or anything. The side panel of Select Table is empty and the Add Table Query Button does nothing. When pressing Add Table Query Button the browser console prints this: Uncaught TypeError: Cannot read properties of undefined (reading 'id'). etc. Version: L2024.2.0.416Solved1.7KViews0likes5CommentsSum based on OR condition
Hi. I'm trying do a simple sum based on OR condition of 2 column of a table. For now I just want to display a number (that later I will use for a more complex widget) by summing the elements of the table that satisfies a string condition of a column and a number condition of another column. So, I want to go from this simple SQL query: select sum(case when level = 'disabling' or coalesce(problem_issue_id, 1) = 48 then tickets else 0 end) from fact_tickets f The closest I could get is by setting this formula withing the widget: ([Total tickets], [level], [problem_issue_id]). In which I filtered [level] to be just "disabling" and [problem_issue_id] to be 48. The problem is that this formula is setting a AND condition, when I press "Analyze SQL query" button I get this: How can set that AND condition to be an OR? Is this even the correct path to do this? Thanks!1.8KViews1like4CommentsBigquery can't retrieve data but can see schema due to wrong dataset location
I can retrieve all datasets and tables from Bigquery but when trying to actually get the data (preview or executing custom sql). It happens for Live connection and Elasticube. I use a json service account file to authenticate and withing Google Cloud logging I see that Sisense is trying to fetch the data from US which is not the location the dataset is. I don't know how to fix it. Google cloud log: when trying to fetch data: "Not found: Dataset PROJECT_XX:dataset_xx was not found in location US"