-
How can I upload a CSV file using pydomo
Hi, I have uploaded a csv file using pydomo which is Python data connector for Domo, using below code - import pydomo as PyDomo PyDomo.Domo(Domo_Client_ID, Domo_Client_Secret, api_host = 'api.domo.com').datasets.data_import_from_file(dataset_id = '1234abcd', filepath = 'aa.csv') Above lines of code ran successfully,…
-
Connection error when trying to initiate Domo using R
Hi, I am trying to initiate Domo from R using the DomoR package. Below is my code - library(DomoR) DomoR::init('my_company', "aaa51e07b27d5d8828517xxxxxxxxxxxxxxxxxf90f4") With this code, I failed to initiate and got below error - Error in curl::curl_fetch_memory(url, handle = handle) : Timeout was reached:…
-
Select rows from a datset based on Date
Hi, I have a dataset with one column as Date. Now I want to create an ETL process to create a new Dataset from the existing one based on rows which correspond top 10 days in the Date column of the existing data. I checked on the available options for ETL but failed to see any direct way to do this. Only option that is…
-
Time series plot with Primary and Secondary axis
Hi, I have below data; DateCategoryValue02-08-2019Cat11002-08-2019Cat22002-08-2019Cat33003-08-2019Cat111003-08-2019Cat2-22003-08-2019Cat323004-08-2019Cat13004-08-2019Cat24004-08-2019Cat340 With this data I want to create a time-series plot with below properties : * Cat1 and Cat3 will be plotted with the Primary axis and…
-
DomoR connector error : Not Acceptable (HTTP 406)
Hi, I was trying to use DomoR package directly to download a dataset onto R. I used below codeset - > library(DomoR) Welcome to DomoR > DomoR::init('XXXXX',…
-
Fetch Dataset based on some selection criteria using DomoR
Hi, I use DomoR package to download a Dataset onto my R environment for further processing. I am wondering is there is any possibility to fetch data based on SQL query. Like, instead of fetching entire dataset, it is possible to fetch data like select * from Dataset where Age > 20 My original Dataset is quite huge so I…
-
Create a new table from existing table with data for last few days
Hi, Let say I have a table that corresponds to a Domo card. This table has a field with type 'Date' Now I want to create another table that is exactly mirror to my 1st original table, but will consider data only for last x-days starting from my System-date. Furthermore, that new table should be updated automatically when…
-
Creation of a new variable based on delimiter
Hi, In my Data I have a column name 'Origin_Data' which holds data like 'aa/df', 'bb/saw', 'asd/erw' etc. (character type) Now I want to create a new column say name 'Final_Data' who values will be just the left part of the values of 'Origin_Data' after splitting with '/' - delimiter i.e. 'aa', 'bb', 'asd' etc Any pointer…
-
R connector to Domo giving 406 error
Hi, I am using R connector package 'DomoR' to fetch one dataset which is used in one of the Domo cards as below: > library(DomoR) Welcome to DomoR > DomoR::init('xxxxx',…
-
How can I arrange Items in a Stacked bar chart?
Hi, I have created a Stacked bar chart as attached. Now I want to arrange the items in that chart in descending order i.e. the item with Maximum negative value should sit on the top then the 2nd max and so on. I tried with 'SORTING' field in the chart building option, however could not succeed. Any pointer would be highly…
