-
Domo in Excel/Powerpoint
Hi everyone! I am currently exploring what is the best option for bringing Domo into powerpoint. Currently I am using a mac and want to import tables and cards into Powerpoint but with the tables I can see that powerpoint doesnt give the best formatting options ($, color formatting) the way excel does. Is there a way to…
-
formatting in a table
I have a table like this: Category | Actual | Budget Revenue | 4.50 | 5.50 Sales | 4,250.00 | 5,550.00 For this table, I have in a pivot table, and I want the revenue to be formatted with the ($), and the sales, I want to not have decimals. How can I do this in a beast mode? If I format this for the column on the card it…
-
Pivot tables
I dunno why, but some of the time I cannot wrap my head around pivot tables. Here is what I want to do and here is how my data is structured and the column headers…. Account | A Prime_TV Revenue | B Prime_TV Revenue | A Premium_TV Revenue | B Premium_TV Revenue Pivot table I want… TV Category | Company A. | Company B…
-
app studio text
I am starting to use App Studio and would like to do something creative with text. I would like to give a description of charts with text. For example, i would like to create some conditions such as ''met budget'' and to have this in green, otherwise if we did not hit budget to say 'miss budget' based on numbers. Is there…
-
Workbench security question
Hi all, I am using Workbench on an on premise server. What I wanted to understand is if because of this….is all of the data on my server only on the server? Or is the data still being uploaded to the cloud?
-
size of dataset
Is there a way in Domo to understand the actual size of the dataset? I know we can find the row count, but I am not sure how to find the size in GB/TB.
-
Many rows
I need to find a way to pull in many rows of data. I have two months worth of data which is essentially 110M rows. I need to pull in at least a year. Is there a way to do this? I tried the ETL partitioning method but it said 'too many rows of data'. Would workbench work with partitioning here or would I get the same error?…
-
i would like to color the table text
hello, i would like to conditional format text only. When I use the color rules, it just colors the background. Is there a way to do this?
-
Unable to Schedule Jobs
Hi everyone, I can manually run a job which works, however when I schedule a job, it says that it executes however the job does not run and I don't see it in the UI. When I look at the viewer, I see the following error: 'Could not fix consecutive blocks of CRON schedule' Does anyone know how to resolve?
-
indexing on domo
Is there a way if i have a dataset to simply create a unique id? For example, if I have a dataset of 10 rows and I want to label the row ID, and start at 1, then 2, etc.
-
2 datasets and filtering
I am trying to dive into using App Studio and I want to filter but I also want my cards and BANS to be affected by filtering. The challenge I have is that I will have at least 2 different datasets for the source. Is it possible for different cards to change when filtering when you have more than 1 dataset?
-
Snowflake use cases
Hi everyone, currently we use Domo and have some data sources we collect from multiple businesses. Without going into much detail, does anyone here use SnowFlake and have it integrated into Domo? If so, or even if not, what are the benefits of using Snowflake along with Domo?
-
API Partitioning
Hi all, so I want to use the Domo API's to do partitioning. That is, I want to send data daily, and I do not want the data there to be overwritten. I am trying this but I think it is being overwritten: https://api.domo.com/v1/datasets/{dataset_id}/data?updateMethod=PARTITION Is this the correct way to upload via partition?…
-
API using partition
I have a question. I am using APIs now and I would like to know if it is possible to do partitioning using APIs. I know using Magic ETL and using Workbench you can do it, but can you do it using APIs? If I can't is the next step doing recursion? The reason for asking is that I am uploading data daily and would like to add…
-
using Domo API and partition
Currently i want to append data using the API append method. However, i also want to update the last 2 days 2 a dataset on a cron job so that i do not miss a day. I know partitioning would only keep the unique record. Is it best to use recursion or partitioning for this?
-
uploading data to a dataset - Domo Developer API
I am pretty new to Domo Developer. I would like to use a python script to daily upload data to a dataset. Here is my script. def append_data_to_dataset(dataset_id, dataframe, access_token): """ Append a pandas DataFrame to a Domo dataset. headers = { 'Authorization': f'Bearer {access_token}', 'Content-Type': 'text/csv' }…
-
pivoting data
Hi, I have data in this format: Date Island Count 2021-01-02 Aruba 4 2021-02-01 Curacao 9 2021-03-01 Curacao 10 I would like the data to be formatted this way: Island 2021-01-02 2021-02-01 Aruba 4 7 Curacao 9 10 This format is for a table view
-
resursion
i have a large dataset that is too large on the SQL source to bring in monthly so I have to bring in daily. So, I need to find a way to keep a few months of data in Domo. What would be the best way to do this? Should I use recursion? Is partitioning another option? I'm not too sure how these work. Would someone be able to…
-
Time change
Hello, currently I am pulling data via an ODBC Connector and pulling through Workbench. What I am finding is, when I query the data locally on the server I am seeing the correct dates, however, when I am pulling it through Domo the datetime is 4 hours behind. How do I correct this? Currently I am in EST time.
-
window function
I have the following table and i would like to understand how to get the difference between dates: id | status | date 1 | disconnect | april 4 1 | reconnect | april 7 2 | disconnect | june 4 I would like to understand the average days that persons reconnect in the entire dataset. Can a partition function work here? The…
-
Calculating MoM, YoY, YTD in table
Hi Domo users, I have been trying to figure out how to represent some values in a revenue table and hoping you can help. Here is what I have so far: As you can see above, I have something like this cable that I want to replicate in Domo. For the most part I can do this in a pivot table in Domo, however I am not sure how to…
-
Date change in workbench
Hi, I am using Domo workbench. When i run a data feed with a query the time seems to change when I see the data on the webpage. So for example, when I run a query and put it in workbench it is saying July 01st 00:00, however, when I look at the data on the data page it says June 31st 08:00. There is a 5 hour difference. I…
-
Saving States
Is there a way to save data and possibly append to it? Let me give an example. When I pull data from a database, I would like to pull data and when I pull data tomorrow I want the original data to still be there. So I want to be able to see user counts by region today, and then in a month I would still like to see what it…
-
Joinin on Email
I have 2 contact databases where I need to join them based on both phone number, name, and email. I am able to currently join on phone but the email part I am having an issue with. When trying to join on email it isn't working. What is the best way to join on email address and if possible where emails closely match?
-
Formulae function for table instead of line by line
I have two tables. The first table i have a list of telephone numbers. The second table, a list of the first 3 digits of the number. I want to qualify the first with the next. Here is my formulae: case when SUBSTR(Phone,4,3) not in(NXX) then 'no' else 'yes' END so this is fine in that it qualifies line by line. However, I…
-
unpivoting data
I have data this way: Account | Category | Date 12 | Phone | 01/01/22 12 | TV | 01/01/22 13 | Phone | 01/02/22 12 | TV | 01/01/22 I would like to figure out on each date the counts for each subcategory. First i would want the data pivoted this way: Account | Category | Date 12 | Phone, TV | 01/01/22 13 | Phone | 01/02/22…
-
Beast mode for dates
I have a dataset that looks like this: Date. Customers Jan 01. 20 Jan 02 22 Jan 03 26 Jan 04. 29 What I would like to do as a beast mode filter is to only include the first day of each month. So I want a filter that just filers Jan01, Feb01, March01, etc. Is this possible? I would assume it would be some data beast mode…
-
Large dataset import in Domo Workbench
Hi everyone, I have a very large dataset (18M rows) that I want to import and it takes too long. The query is already a grouped query so there is no unique ID. I am just trying to figure out if there is a way to import possibly a one time chunk (the data is for 2 years) and then maybe append the data after that. So maybe…
-
Accessing Dataset
Hello everyone, I am using Domo Workbench, and currently I am trying to run a dataset while using an ODBC connection. When I execute the job, it runs fine, however, when I go to Domo datasets I do not see it there. When I execute from Workbench it is executing as another user (another owner). Is there a way I can still see…
-
Flow for dates
I have the following table: Id Service Start Stop 12 Mobile Jan May 13 TV Feb Sep what I want to do is reshape for a line chart to have counts of accounts for active services: id date service 12 feb mobile 12 march mobile 12 Apr mobile 12 May mobile 13 Feb tv etc…
