Darius Domo Employee

Comments

  • user10655, There is not currently a way to have an editable field in a standard card, although a custom app could likely support that kind of functionality if you are comfortable developing one. Here is a point of reference for our Dev Studio, which would likley be the best tool for the job:…
  • user06033, Unfortunately, there is not currently a way to have the Connector automatically add new campaigns as they are created. The intention is for you to control the campaigns for which we pull data to control what data is made available to your users and how long the Connector will run based on the number of campaigns…
  • artywah, This sounds like something that you could do in mySQL or Magic ETL. I can think of a couple of ways you could do this: * Median: You could find your median and then split the data so that the values below the median go into one transform and the ones above your median go into another (you would have to determine…
  • user04089, Here are a couple of suggestions to double check for causes of the slowness: * Double check your indexes to ensure that every column used in your join condition is indexed (I have added conditions at times that increased my run times until I modified my indexes) * Trim your strings for leading and trailing…
  • user04089, Thank you for the context. The size of the 200 character columns could certainly contribute to the run time. Otherwise, there are some other likely causes of long run times. Do you have any joins? If so, do you have indexes prior to the joins to improve the processing time for those join steps? Here is a good…
  • user04089, Domo doesn't have a hard limit for input DataSets. There are many things that could slow down a DataFlow, and many of those causes could be minimized or addressed through optimizations. Could you please provide more context? * What type of DataFlow (SQL, Magic ETL, etc) are you using? * How many columns do you…
  • DDalt, Thank you for reaching out with your question. Redshift is great for many use cases, especially those that require SQL transformations on larger data. The downside is that the Redshift service and resources alotted to processes are managed by Amazon and remove some environment controls that Domo otherwise has for…
  • user09039, We do not have an ElasticSearch connector at this time, however, other customers have considered third party ODBC drivers to use Workbench to pull data from ElasticSearch environments to push into Domo. We don't have any partners in that space at this time, so there is not a driver that we promote, but you may…
  • rollthejewels, It sounds like you need to add some entries to "Enter Fields to Exclude" for your use case, but all of the "Additional Options" you are referring to are optional, so you don't necessarily have to fill them all out. Here is a simple description of the fields that you are referring to: * Header tag: If your…
  • user01959, We don't have dataset row limits, just overall account row limits depending on the Domo package you have. With our Professional and Enterprise plans, these row limits are not likely to impact an individual dataset. To avoid performance issues, I would suggest avoiding the following with large datasets: * LIKE…
  • MaureenDIG1, There isn't a way to save multiple pre-filtered views of a card without making new versions of the card, however, you can add Quick Filters to the card so your Creative Director can change filters quickly without leaving the Details view of the card. Here is a good article to get started with Quick Filters if…
  • user09693, You may consider creating a Sumo table for this use case. You could have the data in an unpivoted format to prepare for this approach. For example, you could have a few columns, such as: Date, Customer Name, TS-01-001,TS-01-002, TS-01-003, etc. With the data in that format, you could then pivot the data using a…
  • Hello, Crockett, You can pivot data with the functionality of our Dataflow tools. The easiest approach to pivoting your horizontal data in preparation for joining it to the other loan data is through Magic ETL. Here is a good resource to refer to on this topic (under the "Collapse Columns" heading):…
  • Thank you for that information. I see that you are in communication with our Support team. The recommendation there was that you prepare a row for each user so you can have a dynamic range on a per-user basis. The best way to do that is with a dataflow that joins the start and end dates onto the username, creating one row…
  • @user03841, Sorry for the delay. You asked how you would identify the Date Range start and stop dates for active/inactive classification. This would depend on your definition of that time frame. Is it the last ____ months? If not, how do you define the active range? Overall, it sounds like you are working with a highly…
  • @user03841, Based on your use case it sounds like a dataflow would be the best way to establish a reliable definition of an active employee. To retain as much data as possible, I would suggest generating a value that acts as a flag to identify users as active or inactive. This would allow you to leave all of the data…
  • @PodiumMason, you bring up a good point. The aggregations would be limited by the groupings for each row in the card. One potential solution would be to generate columns for the beginning and end of your date range using a dataflow. These columns would have the same values for every row in the dataset and could be…
  • Sorry for the confusion, user03841. My answers assume that you are applying a date grain to your card, which is how I understood you when you said "the 'from' and 'to' of the DOMO Between fields". If you have applied a date grain to the card (Last 6 months, Previous Quarter, This year, etc), you can use the MAX and MIN…
  • user06410, No problem. Please see my responses below: * To push data into Domo from a cloud-based solution, and assuming that you have the ability to run scripts, you can use our Datasets API (https://developer.domo.com/docs/dataset/import-and-export-data) or our Streams API…
  • user06410, Could you please clarify your end goal a little bit? Are you trying to pull data from your EMS solution and push it into Domo, or is the reverse your end goal? If you are trying to get the data from your EMS solution into Domo, we have a tool called Workbench. It is a solution for getting data, especially from…
  • user08705, Than you for reaching out! Applying conditional formatting based on a different column is not currently a feature in Sumo Cards (where pivoting is available). Please search our Ideas exchange here https://dojo.domo.com/t5/Ideas-Exchange/idb-p/Ideas. If your idea exists then vote it up, otherwise submit your idea…
    in Pivot Table Comment by Darius June 2018
  • Using the MAX and MIN functions, you will be using the earliest and latest dates available in your data rather than predetermined dates. By `your_date_field`, I am referring to the same date field that you are using in the date range grain (the Between dates) in your card. Please let me know if there is more that I can…
  • Hello, user03841, You could use Aggregation functions in a Beast Mode to select the earliest and latest dates in your data that are in the date range you are filtering to. For example, you could do something like: CASE WHEN `TermDate` <= MIN(`your_date_field`) THEN 'Exclude' WHEN `HireDate` >= MAX(`your_date_field`) THEN…
  • Is the goal to have this group created for your category (usually X-) axis, or is this for your series in your chart?
  • Hello user00450, Do you want users to sort data in table cards without having access to edit the underlying card? We don't currently have a feature in our table cards for sorting on the fly, but that would be great feedback! You may be able to accomplish your goal using a Sumo Card however, as there are more options to…
  • Thank you for getting back to me, Trent-T. If you run into trouble, please feel free to reach out to the Support team to get you back on track. Thank you for your time!
  • Hello Trent-T, Thank you for posting your inquiry. The most simple solution would be to create a new dataset that runs once and pulls in your month-end data, but that may not be a viable solution if you have many reports and this may make it difficult to locate the right dataset when building a visualization due to the…
  • Hello mbauer, This would be best addressed through a support case. You can create one by going to support.domo.com in your browser and logging into your Domo instance. If you have trouble creating a support case, please feel free to post so we can review.
  • Hello DataSquirrel, Workbench datasets are modified, managed or updated through Domo Workbench, so settings are not available for these datasets inside of your Domo instance. It sounds like the behavior you are seeing with your Excel connectors may be a bug. Could you please reach out to Domo Support with specific dataset…
  • Hello John-Peddle, We are happy we could review and discuss your question with you. We wish you the best of luck in applying Scott-Thompson's approach through your engineering team. Have a great day and new year as well!