Comments
-
A few options you might try: 1. Depending on the end view you're after on your cards, you could leverage a distinct operation in a calculated field: count(distinct `fieldName`) 2. Leverage either the R or Python plugins to pull down the data, run a de-duplication function, and then push the data back into Domo: R:…
-
Can you share a screenshot of the error you're seeing when you call the stored procedure? Is it possible for you to share your script or a version of it so we can take a look at the transforms? In general, you should be able to do the following: 1. Create a stored proc in a given transform 2. Call the stored proc in the…
-
One option might be to use the period over period chart types if you have a date dimension in your dataset. This will give you the variance by default without needing to create a calculated field. Otherwise, you would need to create a new field with the variance calculation you're wanting to display, such as the percent…
-
See attached screenshots. You can remove the min/max/avg lines and then add a single calculated line back onto the Bar Chart via the chart properties: 1. Grid Lines: Check the "Remove Min/Max/Avg Lines" box. 2. Scale Marker: Set the "Type" to "Line" and choose the "Value Type" you want to display on the chart. Hope that…
-
Hello - please see our documentation on our developer site for "Dev Studio" apps under the "Getting Data section: https://developer.domo.com/docs/dev-studio/getting-data
-
Hello, You can calculate the overall mean using the chart properties on a Bar Chart type card as shown in the attached image. You can then pair this with an "avg" of the metric / measure in your data trended over the given dates. The time grain on the card can be adjusted dynamically to day, week, month etc and all of your…
-
Looks like you already checked on the column data types. Do you have any trailing or leading spaces that might cause a failure to match between the join keys?
-
I see - have you confirmed that the datatype of the columns in the join condition are the same? That might be the cause of the blanks. Could you share a sample of the data that you're attmepting to join or take a screenshot of your Magic ETL join?
-
Have you tried swapping the inputs and changing from a left to a right join? See the attached photo - your biggest dataset should be the right side of the join. Let me know if that works for you.
-
Are you using Magic to do your left join?
-
Hi JasonWebber, Some suggestions for performing a closed loop style analysis in Domo could potentially involve the use of Notebook Cards, Buzz, Projects and Tasks, and/or WebForm or Excel sheet to track comments or annotations for a given dataset. Notebook Cards: -Drop a notebook card onto a collection to pair it with the…
-
Hi lfarb, Here's are two addtional resources for building period over period calculations. Dataflow: https://knowledge.domo.com/Prepare/DataFlow_Tips_and_Tricks/Period_over_Period Beastmode: http://knowledge.domo.com?cid=beastmodecomparison We've also been working on an enhancement for period over period cards that is…
-
Hi JasonWebber, Thank you for the suggestion which is a great idea! We currently do not have such an offering. Please visit the Dojo Ideas Exchange http://dojo.domo.com/t5/Ideas-Exchange-suggest-and-vote/idb-p/Ideas. You can search existing ideas and then vote for it if it matches what you have in mind. If you cannot find…
-
That should be the right external link to take you to the help center documentation. You can also try to navigate to the Help Center from inside your Domo instance and do a search for the QuickBooks connector. If that doesn't work or you still can't access the documentation, reach out to your CSM or Domo Support and the…
-
You can use the Workbench transformations to add a column that inserts the current date. This should give you the date column you're looking to add.
-
Assuming you mean the QuickBooks Online Reports Advacned Connector, there isn't an option to pull in customized reports, see the help center documetation here: http://knowledge.domo.com?cid=quickbooksonlineadvanced Another option for you might be to extract the report data from QuickBooks Online and upload it to Domo.…
-
Hi abf2dh, Sounds like the data previews and uploads correctly but throws that error message? A couple things you can try: * Start over with a new excel connector and try uploading the file again * Check this post for some of the common issues seen when uploading excel files:…
