-
magicParseJSONで取り込んだデータの型が文字列から数値へ変換されてしまう
JSONの取り込みにmagicParseJSONを使用しています。 以下の様なJSONを取り込むとします。 {"lat":"35.6569176", "lng":"139.7044403"} これをMy Connector Developer上のData Previewで確認すると、想定通りに lat lng 35.6569176 139.7044403 表示されるのですが、DataSetとして一旦取り込んだ後で確認すると lat lng 35.6669 176 139.70 となってしまいます。 実際のJSONはネスト構造で属性も多い為、できればmagicParseJSONを使いたいとおもっているのですが…
-
Report Customisation
Reports are key to our business ~ we need to send reports to customers at a regular, tailored frequency. In our previous BI tool we could 1) export as PDF 2) customise the exact layout of the report 3) attach the report as a PDF The only customisability I've thus far found in Domo is adding filters per report. Can anyone…
-
Dataflows Created
On each dataset, there is a tab showing how many dataflow created with this dataset. (see attached screenshot. there are 6 dataflow created) Is there any easy way I can track down which dataflows are created using this dataset? p.s. The data lineage only shows the map downwards not upwards. Thank you!
-
Specify different date formats for multiple sources in ETL
I am combining a number of data sources with date columns using an ETL before performing other calculations on them. Some of the sources have Australian date format (DD/MM/YYYY), and others have US format (MM/DD/YYYY). The ETL gives me results in YYYY-MM-DD format, where it's actually incorrectly converted some of the…
-
Card will not load in CHART view
I have a card that has been working for months but today, the data won't load into the card (but dataset works and is updated) and it will only display if you switch to TABLE view but not with default CHART view. I have some math variables defined that are pretty heavy in using CASE stmt and some calculations. See…
-
Continous data line graph
We sometimes have the problem when building line bar chart with companies as series value and displaying e.g. the number of users in a specific time period we get dot data points in case the following period has 0 amount. Is there a way to show it as continous line that when the number of users in week x+2 is greater than…
-
Allowing all the data to show in the column without getting cut off.
If you have a table with a column that shows a lot of data how do you make sure the data doesn't get cut off. I tried general/text wrap and that did not fix the issue. Thanks
-
Select multiple measures at one time and add to a series
How can we select multiple measures at one time and add to a series? We have approximately 900 measures that we want to add to the card and be able to filter 4 ways? Thanks in advance for your help!
-
Creating "Other" group in a chart
How do I write a beast mode that will group a large collection of small values into an "Other" group (Say any with a sum of values under 200) without specifying the members of that group? Edit: I should mention that these would be sums of multiple values. Meaning multiple rows per day but the sum is still <200 in the time…
-
Google Analytics Custom Dimension fails
I have a Google Analytics connector already working, using a custom dimension labeled 'dimension1'. The docs say to enter comma separated custom dimensions. But when I did that, comma separated, the report totally fails. How can I get my other Custom Dimension in GA to show in DOMO? Attached is a screen shot.
-
Sumo cards display rows offset when dimensions are grouped, is this intentional?
When creating Sumo cards, when grouping all the dimensions that are displayed, the row number labels offset, and this persists after saving. I had another user test and they had the same results. If this is intentional, it seems awkward as it makes it difficult to line the row number up with the dimension value. To…
-
Graph between user-selected Dates based on relative scores
I have a dataset created from a recursive flow that's updated daily. It has columns that include: User-ID Date UserScoreOnThatDate I can easily graph a set of users between dates selected by viewers in a Quick Filter. But the viewers would to see only users with scores that are higher or with scores that are lower when you…
-
Sorting columns in a table chart when being viewed by a Customer
When I customer is viewing a table chart; Is there a way to allow them to sort a column?
-
Sorting Ascending Count with a Series not working
I have created a card using the stacked horiztontal bar that has a count of "Key Message Name" on the X axis and the "Key Message Name" on the Y axis. I am able to sort the counts ascending before I add a series to break out each column by customer type but after adding a series the ascending sorting functionality does not…
-
Bringing in Data Efficiently from Excel (multiple documents and sheets)
Hi, I have a set of about 25 excel documents, each with 7 sheets with data on them. I have a few questions about this, as this sort of problem is common in what I've been having issues with, but in a few different ways. 1. Is there a way assuming all the data is formatted the same on each sheet and document, to input all…
-
Timeline based Table
We have a lot KPIs that we track on a weekly/monthly/ quarterly basis. In order to show e.g. how our customers are performing over the time by a certain date frame we currently need to use the pivot table view. If we use the cards and want to show the numbers in a table form we need to user beast mode calculations to…
-
Dataflow Drafts
Since last weeks we have draft versions for some our dataflows but don't know why? We've further recognised that for the draft versions the autmatic update don't work anymore? Does anyone know how to change the status and why we suddenly have the different statuses?
-
hierarchy
I am trying to create a map that displays a measure. When I select a country the map recognize the name of the country and it is able to show the value for the relevant area. What I want is to be able to see the data for an aggregation of countries that are part of an area. In tableau I was able to create a hierarchy as…
-
Exclusion Join or method to achieve the same type of result
I've got a dataset I'm working with that has a large amount of RepairOrder data, in this particular instance I'm filtering for any RepairOrders that are not closed that have costs applied to them. This is very straight forward, however I've discovered that in some cases I've got duplicates that exist, one closed and one…
-
Creating PDP Policy using Python
Hi All, I am having some issue creating PDP policy through Python. The script runs without error and creates the policy but it does not add users into that policy. I wrote this based on the domo github repository. The goal is basically to assign the access to the data based on the office column in master dataset and some…
-
Can I push Input data from a custom app into a dataset?
I'd like to create a custom application that contains input fields that users can type in data and save it. There is lots of documentation about getting the data from your dataset to your app, but what about input data from your app to the dataset?Can you just run a regular http.post request? Is there a domo.post feature?…
-
Does anyone have a currency toggle implemented?
Does anyone have a toggle or switch implemented that allows the currency to change? Thinking this would be set at the page level or better yet, at the user level. User must be able to change the currency to whatever is required. Thanks, Bob
-
Email Connector Returning Undeliverable
I am using the email connector to automate and consolidate some daily reports that I receive. When I have emails sent to the email address supplide by domo for the connector occasionally I get an undeliverable message. It says 'that When Office 365 tried to send your message, the receiving email server outside Office 365…
-
Filter Aggregate field work around?
Hello, My delema is that I have a Start Date, Phone numbers, and a #Max Call field for particular campaigns. What I need to do, is figure out the count of a single phone number called with a certain start date and see if it ends up exceeding the max call nummber. I actually managed to do this in a table with case when…
-
SharePoint Lists - Help connecting
Is anyone had luck connecting Domo to SharePoint lists? I was able, with Domo support, to connect to our cloud based SharePoint site. I cannot get Domo to connect to the specific list. It keeps giving me an error to the specific list. The list name has a space in it but I cannot change it. I have a ticket into support from…
-
Pausing branches in Magic ETL
Is there is a way to pause a branch on the ETL layer? We have flows that create more than one output, and it would be helpful to skip processing for certain branches of the flow during specific periods. For example, in the below screenshot we would like to pause the “star” branch so that nothing on the top of the screen is…
-
bug in Domo's period over period chart
It looks to be a bug in Domo's period over period chart. The March data is in the dataset and if I switch the card to a regular Bar chart for the last 12 months the data is complete. Switching to the period over period chart and comparing for the last 12 months results in the issue you see. Also, the data for March and…
-
CourseBuilder - embedding domo videos?
I'm looking into using the coursebuilder but I'm confused on something - Can you only use videos from an external source? Can you not embed videos from Domo University / Domo Self-Help videos in your course? I only see options for external sources such as Vimeo or Youtube, however. I don't understand how this is useful -…
-
Page Filter - Multiple Cards - Multiple Data Sources
Greetings, all! I would like to build a weekly dashboard for my school district. I would like to report student attendance, staff attendance, discipline, and grade distribution. Unfortunately, these 4 pieces of data come from 4 different sources with 4 different data definitions. I have to do some magic to get common codes…
-
How do I format the legend in a bar graph?
I have a card with a bar graph that shows: X Axis: Interventions Y Axis: Average Score of each intervention (0, 1, 2, 3) Series: Interventions This produces an average score for each intervention. The Value Scale (Y) is set to 0, 1, 2, 3 and the Category Scale (X) lists each intervention. The legend on the right simply…