-
POP Calculation and Auto Filter using Beast Mode
Hello Everyone, I am new with Domo and nice to meet you all. Actually, I dont have any experience with this type of platform and have limited knowledge in SQL, ETL, and Beast Mode. I am currently trying to create POP calculation and auto filter using beast mode from aggregated daily numbers attached below. I have tried…
-
Card view count
Card view count is overly execrated and misleading... View count increments even if I refresh the page... and not accurate representation of actual views.. Can’t they make it so that only the views other than the card owner is counted..? Disappointing.
-
Connector onedrive fails
At first the connection and the updates of a file in my onedre were successful, but until today the file still fails if it exists inside my onedrive but dome keeps giving me error.
-
is it possible to insert a card in a table card
Hello, I created a trend line card, and wanted to show this trend line in a table card. Is it possible to do it? Or if there is another way to do it? Thanks, Olivia
-
How can I bulk add annotations to all of my cards?
Hi, We use domo quite aggressively and have started implementing tests across our ads and we would like to track when things changed/happened using annotations. The issue is we have multiple cards (all representing something different) but all use the same data source and we do not want to have to add date annotations to…
-
What happens when you deactivate a connector? Can it be reactivated?
Our company is currently using the trial version, where we can only have 4 Connectors active at once. We are currently making use of all 4 connector slots, but would like to test another type of connector. If I were to deactivate one of the connectors now, would I be able to reactivate it at a later point without having to…
-
Support for Postgres HSTORE and JSON data types
Hi, I am new to Domo. My company provides a multi-tenant SAAS service and we support custom fields on a per client basis. Our implementation uses the Postgres HSTORE data type (similar to JSON, large text field with key-value pairs). So, data for one client may include data with keys 'fruits' and 'vegetables' where another…
-
How to Translate Tableau's Fixed function in Domo?
Hi, I encounter a lot of Fixed function from Tableau when trying to translate it to Domo, but I can't seem to find any reference to such function here. One example is a measurement (let's call it 50-percentile Area) that looks like this in Tableau: { FIXED [Area group]: PERCENTILE( { FIXED [Building Code]:AVG([Number of…
-
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…
-
Data Warehouse best practices
Usually I used to use a single data warehouse arquitecture managed by the company. Strategically my company decided to use the data warehouse provided by Domo but I honestly still have doubts about this decision. I have some questions on this topic: 1) Domo's data warehouse is enough? Taking into account that we're a group…
-
Googleスプレッドシートアドオンについて
Googleスプレッドシートアドオンについてアクセスキー生成の際に必要な権限は「監査」、「データ」、「ダッシュボード」、「ユーザー」のうち何が必要になりますでしょうか?
-
Using a Postgres dataflow to split a comma-separated string into separate rows
Trying to split a comma-separated field into rows. Input looks like this: JiraID | Zendesk IDs 1 | 5,6,7 Desired Output: Jira ID | Zendesk ID 1 5 1 6 1 7 tried using unnest(string_to_array("Zendesk IDs", ',')::integer[]) but am getting errors that unnest(integer[]) not found. Any other way? Thanks!
-
Did you find card creation easy?
I find it lil difficult https://domo.com
-
How can I import custom goals from Google Analytics to Domo?
How can I import custom goals from Google Analytics to Domo? I am trying to create a card to show GA goals but cannot import them indicidually from GA.
-
How do I calculate time difference between two values in the same column and also group them?
I'm trying to calculate the time difference between API calls but also group them by requestID and day. So far, I have the following Beast Mode to reformat my `requestTime` into time and tell the difference. Meanwhile, I'm trying to use the card itself to group by requestID and date. Currently nothing is coming back. Any…
-
Creating a Quick Filter from a CASE Expression
I'm trying to create a quick filter based off of a case expression and I'm running into some trouble because the dates overlap as you can see below. When I click on the first section it works great but when I click on 'Aug 2018 - Oct 2018' it only gives me Oct's numbers because August and September are already in July -…
-
How to create a drill path that will apply filters to a different Domo page
A coworker showed me a very cool way to use a table card to allow you to "drill" into an entirely different page in Domo and automatically apply page filters based on the data that was in that row of the table card. I had to share: CONCAT('<a href=''https://abbott-molecular.domo.com/page/1644062327?pfilters=[' -- Change…
-
Domo Scheduled Report Service
Hi Everyone, My question is I want to use the Schedule Report service. But, it seems it doesn't have any format options like send it as csv/text/ppt. It sends only card thumbnail and link to view in DOMO. It there a way to schedule a report as CSV or Text. Thanks, Arav
-
Insights Beta - turn it off
Is there any way to stop the Insights Beta from showing up next to all cards? I clicked the check box for "Hide Insights for non-card owners" on several cards and keep seeing them when I view the card again. It's really annoying.
-
Workfront Advanced Connector - unable to pull in planned and actual hours
When using the Workfron Advanced connector, I am unable to pull in the following fields from the project report: * Planned Hours * Actual Hours Has anyone successfully pulled in these fields? Thank you!
-
How to only show the amount of monthly value only once instead of the sum over the whole period?
Hi, so I have a dataset that looks like this (fictive dataset): Employee Name Date Sales Monthly Quota Sally 11/3/2018 5,000 10,000 Andrew 11/3/2018 4,500 15,000 Michelle 11/4/2018 3,500 9,000 Sally 11/6/2018 1,000 10,000 Sally 11/7/2018 700 10,000 Andrew 11/8/2018 2,500 15,000 Andrew 11/9/2018 3,000 15,000 Sally 12/4/2018…
-
Did anyone receive this error message in SQL data flow: BLOB/TEXT column 'ds-value' used in key spec
Hi, I am receiving the below error message while creating an index on a column. Did anyone experience this issue? The database reported a syntax error. BLOB/TEXT column 'ds-value' used in key specification without a key length Thanks, Srujana
-
Boxplot & Histogram Charts
The boxplot and histogram chart types are the ones that I'd use most often but I almost always get a "Warning: Not all the data is shown" error, which leads me to believe that Domo is unable to handle the volume of records I'm trying to plot.
-
Quick filter doesn't appear on card
Hi I have a stacked chart with a legend. I've added some filters to the card and they are enabled as quick filters. However it doesn't the quick filters, even if I hide the legend. Any ideas?
-
What does this error message mean: "Domo is ready, but MySQL returned "DAY_OF_MONTH""?
I have a couple of datasets that have been updating daily without issue for close to a year. However, starting today they both have stopped updating and now I am seeing these error messages whenever I try to run them: "Domo is ready, but MySQL returned "DAY_OF_MONTH"" "Domo is ready, but MySQL returned "YEAR"" We are using…
-
How to only show the amount of monthly value only once instead of the sum over the whole period?
Hi, so I have a dataset that looks like this (fictive dataset): Employee Name Date Sales Monthly Quota Sally 11/3/2018 5,000 10,000 Andrew 11/3/2018 4,500 15,000 Michelle 11/4/2018 3,500 9,000 Sally 11/6/2018 1,000 10,000 Sally 11/7/2018 700 10,000 Andrew 11/8/2018 2,500 15,000 Andrew 11/9/2018 3,000 15,000 Sally 12/4/2018…
-
Extracting time from datetime stamp
I am trying to extract the time from a timestamp in a redshift dataflow and cannot get the hours to extract correctly. My datetime field is in UTC and I need to convert the time zone to EST which is fine but when I try to get the time from the time stamp it returns the hours of the UTC time and not the converted timezone.…
-
In One card can we call another card?
How we can call one card in another card? Is there any concept like Parameter selection of choosing which view to see??
-
Working with time values/measures
I was informed by Domo support that there is no accomodation for seconds-to-time in magic ETL. Doing this transformation in Beast Mode makes the time value a dimension, which I would not be able to perform calculations on. Is there any way around this? I am trying to make cards for call center metrics like average speed of…
-
Calculate price change from period to period
Hello all. I'm trying to show the change in price month over month. For example, I'm trying to show that the OpProgramPrice has changed $0.01 from AccountingMonth 19-01 to 19-06. Any ideas on how to do this? See the table below. I've already tried this case statement to have it focus on 19-06 and minus 19-01 but it isn't…