COLUMN CHART SHOW ALL CATEGORIES EVEN IF NULL/0/MISSING
Please reference the attached excel worksheet. My goal is to show all horizontal categories, even when data = null/0/N/A. Currently, only 3/6 categories appear and I've tried nearly every Sisense KB article I can find related to null/N/A values. THANK YOU!!!Solved6.5KViews0likes4Comments
Notebooks R Code ERROR: Failed to parse run metadata json with error: Unexpected token '<', "<?xml v
Hello, I'm getting this error when trying to run basic R code in Notebooks and cannot figure out how to fix it or why it is even occurring. Any thoughts would be greatly appreciated! ERROR: Failed to parse run metadata json with error: Unexpected token '<', "<?xml vers"... is not valid JSON999Views0likes0Comments
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 for the best way to proceed. Thanks1KViews0likes0CommentsAccessing custom columns/tables from Notebooks
I'm looking for ways to access custom columns/tables that are created within Elastic cube data models, from `Notebook` feature within Sisense. Context: We have a Sisense cloud account We have a Elastic cube (EC) model that is built from Snowflake data, local CSV files etc We have created custom columns within this EC in our FACT table Now, from notebook in Sisense, I would like to access these custom columns From notebook I can access tables/columns that are in snowflake but not the custom columns created within EC. Is there a way? Thanks1.3KViews0likes1Comment
Error when trying to connect Notebooks to local MySQL Server Instance
Hi, When trying to connect our instance to our local MySQL Server instance, we have a generic error (Unable to connect). We have checked that we are able to connect with those credentials and host data from any server and terminal, but we are getting this error in Notebooks. We are not able to locate the logs or pod related to the error. Just an entry in combined.log with no detailed information (just unable to make a connection) Any of you was able to connect to a local instance or have an idea about how to solve it? BRSolved4.8KViews0likes3Comments
What is sipynb file format?
What is a sipnb file format for Jupyter notebooks import/export? I tried to google it and found absolutely nothing) The user case is the following: sometimes we need to further develop notebook's code that is already used on prod. So I would like to export a notebook and open it in Jupyter notebook locally. But I can only import it with sipynb format and cannot open it in Jupyter later. Any comments appreciated, Larisa2.7KViews0likes1CommentHow to call Python dataframe output in Sisense Notebooks to use as an input in other blocks.
I got the Python dataframe output as below. >>output = pd.DataFrame(data=mymodel,columns = ["Y"]) >>print(output) >>SisenseHelper.save_dataframe(output) Would like to see how to reuse the output in other blocks or save it within the Sisense Notebooks.989Views0likes0CommentsREST API and Python
i'm a Python newbie looking for more REST API script samples using Python. For example, I'm trying to export a simple user list with email, firstName and lastName with a certain search value using the 0.9 GetUsers endpoint. I have tested this in the Swagger interface and get the correct results. I'm trying to use Python to access the data without success. My code looks like this: import requests import json headers = { 'X-XSRF-TOKEN':'eyJhbGciOiJIUzI1NiIsInxxxxxxxxxxx0ZW5hbnRJZCI6IjYxYjExNmI2OTdiYTBiMDAxYTk2MTgxMyIsImFsbG93ZWRUZW5hbnRzIjpbIjYxYjExNmI2OTdiYTBiMDAxYTk2MTgxMyJdLCJjc3JmVG9rZW4iOiJIaE1yWldBRzBlRUVncG9MRm5VNldlL0J3dEQ4cWJPRkR4azZpdThpVUdzNUh2ZW1haGh3dEJianBsaUYvY0dSIiwiZXhwIjoxNjQ0OTQ5NjM0LCJpYXQiOjE2NDQzNDQ4MzR9.9tWIp0XDzEtZu9Q0WTtSrzB8uGRZM0QFsar7lqZE1wE', 'accept': 'application/json' } url = 'https://xxxxx.yyyyy.com/api/v1/users?search=ZZZ&fields=email%2CfirstName%2ClastName' response = requests.get(url, headers=headers) print(json.loads(response.text)) This results in a 401 unauthorized error. I have a feeling something is not right with the header since I did create a user token. Any assistance will be greatly appreciated. Note: This is not really a Notebooks topic, but it was the closest label I spotted. Regards, JimSolved4.2KViews0likes2Comments
