Darius Contributor

Hello John-Peddle, It looks like your original logic was that to be marked '0', a number would have to call less than three times, and more than 50 times. It is not possible for a number to call less than three times and more than 50 times at the same time, so your else statement was being used in all cases. I believe you…

Thank you user09032, For follow up, we would recommend reaching out to support so they can review your card in more detail. Could you please reach out to them to take those next steps? They can be reached through support.domo.com.

Hello byusteve, What is the command you are using in the DomoR plugin when you get this error? This article is brief, but has some information about pulling a dataset from your Domo instance: http://knowledge.domo.com?cid=domorusage

Hello user09032, We were able to get this to work outside of your instance by adding the DATE_FORMAT function to the query. Using your query as an example, that may look like: SEC_TO_TIME(Avg(TIME_TO_SEC(DATE_FORMAT(`Time Out`,'%Y-%m-%d %T')) - TIME_TO_SEC(DATE_FORMAT(`Time In`,'%Y-%m-%d %T'))) Please let us know if the…

Hello DataSquirrel, Please give the following Beast Mode a try and let me know how it goes. This assumes that "AssemblyDate" is a Date type field: SUM(`PartsCount`) / COUNT(DISTINCT `AssemblyDate`) If this presents an error in your card, please let me know what it is so we can investigate in more detail. Thank you!

Hello user04858, To accomodate more detailed investigation, I have sent you a direct email for follow-up. Please continue through that thread, if possible, so we can investigate the behavior you have described in more detail. Thank you!

Hello WHM, Great job on finding the Dojo article discussing page filtering via URL! From your message, it sounds like you were able to accomplish your goal by modifying the example to better match your use case. Do you have any remaining questions about page filtering via URL that I can look into?

Hello user06973, Does the Windows device used for the ODBC connection have the langauge pack for Korean? If not, could you please add it and try the WorkBench job again? If that does not resolve the issue, please let me know and I would be happy to continue investigating. Thank you!

Hello user08782, Data can be exported using the API, but all data returned is in a CSV format. Here is our reference for exporting data using the API: https://developer.domo.com/docs/dataset-api-reference/dataset#Export%20data%20from%20DataSet If you wish to do something else with the data, you can expand your script to…

Hello user04620, To investigate further, we will need some data to review from Facebbook Ads and what you are working on inside of Domo. For this reason, it may be best to open a case with support so they can review in detail without your data being shared on this forum. Are you comfortable opening a support case to…

Hello user08873, Based on the way data is processed by our API, dataset exports are only available in a csv/text format. To convert the data to a json format you could use a parser in your script, but this would fall outside of the functionality of the API. There are many resources you can find online about parsing csv…

Hello user03612, We are limited on what we can do to help with custom app development, but I would suggest reaching out to your Customer Success Manager if you want to explore options on our end to help with custom app development. What you are attempting to do sounds very similar to how CSVs are processed by our CSV…

Hello user04620, The behavior you are seeing is based on the data returned from Facebook Ads API. Are you able to pull the kind of date values that you are interested in through the Facebook Ads API? We would be happy to pass details to the product feedback team about what we can do on our end to expand the functionality…

 Hello wgechter, Could you please provide an example of the data that you are using so we can review and make some suggestions? If you are attempting to create the report inside of Domo using your raw data, it sounds like you could make the aggregations you are looking for with Beast Modes. If that option does not work,…

Hello Randyb, It looks like you are missing a set of parentheses, so only the last Beast Mode was being divided by 5. The rest were being summed to the last Beast Mode divided by 5 with the current format of your parentheses. Please try the following query and let me know how it goes: (((CASE WHEN Sum((CASE When…

Hello arav, Do you have an idea of what the forecasting query would look like if it were inside of mySQL? That will help me know if the query will work in a Beast Mode.

Thank you, jman0527. If you need to keep one of the total rows, but exclude the other one it may require expanding your dataflow. Here is an approach you could take, however, to address your goal, which involves addressing your total rows separately from the rest of your data: 1. Filter for rows that contain "Total" so you…

Hello jman0527, I believe the "Filter Rows" tile would address your goal of removing the totals better than the "Remove duplicates" tile. Removing duplicates removes rows of data where all of the fields specified have the same combination of values, however, you can filter out (or for) specific values. In your use case you…

Hello VictorReyes, thank you for your response. Under extenuating circumstances, support can manually check the usage of a dataset as an input to dataflows. We are working with the product team to expand that into a feature in the Domo platform so it is available to all users, however. Thank you for the suggestion, which…

Thank you jman0527. In the card you could sort on your date and time values to order the data, as you mentioned. I may need some additional information about the total row not matching between reports, but something that you can consider is having two outputs from your recursive dataflow: one that is filtered and used for…

Thank you for your question regarding data lineage, VictorReyes. You may reach out to support to confirm that a dataset is not used as an input to a dataflow if you have concerns. Otherwise, the current best practice would be to keep an ongoing record of what datasets are used by dataflows as inputs. I understand that can…

Hello jman0527, Thank you for posing your question about creating a historical dataflow for phone call data. I hope to address the issues you are seeing. Where are you seeing an odd order for your data? If this is in a card, you can add a sort to order the data how you want to see it. This would apply to the visualization,…