Gimli Contributor

Comments

  • Hello @Culper_Jr , Currently, Poll cards do not allow you to see the underlying data. This would be a great enhancement request. You can submit this by going to your main Domo menu and the to Feedback. In the past, I have used Google Forms. The form results can be output into a Google Sheet. Domo has a connector that will…
    in Poll Cards Comment by Gimli April 2019
  • Hi @user14700, I would recommend reaching out to your account CSM. Your CSM has a couple of resources/tools that might make calculating predictive analytics easier. Thanks, 
  • Hello @user18610 , The best way to do this would be to create a custom chart and define your own regions. Here is a link to the knowledge base that will walk you through how to create this. https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Building_Each_Chart_Type/Custom_Charts Hope this helps!
  • Hello @deannamoore , Here is documentation on the connector: https://knowledge.domo.com/Connect/Connecting_to_Data_with_Connectors/Configuring_Each_Connector/Connectors_for_Media_Applications/YouTube_Enterprise_Advanced_Connector It should go over some things that may provide the date/time of the view activity. 
  • Hello @user06033 , Currently, our Sumo Card is probably what would get you the closest in re-creating this. However, I think this would be a fantastic enhancement to the product to have a chart type similar to this. You can submit feedback to the Domo Product team by going to your main Domo menu and the to feedback. Kind…
  • Hello @user17856 , The issue in the current beastmode is a mix of datatype in the output of the CASE statement. Case When Sum(`Phone Conversions`) < 1 then 'zero' else Sum(`Phone Conversions`) END The THEN statement produces a String value where the ELSE statement produces a number You should be able to use: Case When…
  • Hello @JCMeier , I believe the Redirect URL comes from One Drive. You will want to reach out to them to find out what it should be. If you still encounter issues, please reach out to our support team. Support@domo.com
  • Hello @Randyb, There is a good chance the card can be being grouped by something else. It looks like there is another column in the screenshot. Is this column being aggregated? In addition, any column being used in the sort will group the data. Can we get a full screenshot of the card with all the columns that are being…
  • Hi @WS_CHI, Normally for calculations like this, we use a line+bar graph. Your date becomes your x-axis and then your line/goal becomes your y-axis. The issue comes from how cards function. A card will allow you to have a value as the y-axis and you can add a text value to your 'series' to break out the data. However, in…
  • Hello, For all users except Admin users, you should not have the ability to share cards in a publication group with other users. If you are an admin user you have the ability to share cards with social users. Here is more documentation on publication groups. http://knowledge.domo.com?cid=pubgroups
  • Hello, I would recommend using a %. Assign sizes as xx%. As the screen size changes the elements will also change to stay the same size ratio. In my apps, I use the filter that is available when calling datasets from domo. I create a drop-down filter or something similar and use the API to control the…
  • Hello! You will need to use the LEAD () OVER() or LAG () OVER() beastmode functions to accomplish this. Because we need each comparison to happen on the same row. These two functions will allow us to do this. For example CASE WHEN `Holiday` = 'True' THEN 'Holiday Today' WHEN LEAD (`Holiday`,1,0) OVER( ORDER BY `date`) =…
  • Hi! In the past, I have used the "replace" tile to strip out only the time of a data/time column. I have then converted the time to milliseconds, performed time difference calculations then converted it back to readable time. This was not very easy. I would recommend sticking with your current SQL queries. 
  • Hi, Here is a great knowledge base article on this subject: http://knowledge.domo.com?cid=createrollingaverage
  • Hello @KVincent, You should be able to add this calculation into your previous beastmode. If you just replace the word "newcalc." with your new calculation it should show in your summary number. CONCAT( (newcalc.), (SUM(CASE when `Channel`='RET' then `ordercases`end)),' | ', (SUM(CASE when `Channel`='FSV' then…
  • Hello @Digital_BP, This is hard to describe over the dojo without having an example ETL. I will send you an email to work with you in solving this. 
  • Hello @swagner, It is hard to determine what might be causing long run times in an ETL without looking at the ETL in specific. Generally, it is most efficient to use a select columns tile and select only the columns you need. Next would be to filter your data down to only the rows you need. After filtering your data to…
  • Hello @user02830, Thank you for the awesome question. Currently Date/Time functions in beastmodes and Dataflows return the Server time. All of the Domo servers run in UTC time. This is to promote consitancy. Using a function similar to CURDATE() or NOW() will return the date/time in a UTC format. You can easily work around…
  • Hello @Randyb, It would be great to get a copy of what your calculation is. My thoughts are that the beastmode changes based on the grouping of a card. This is purely an example because I do not know your calculation. If I am dividing by a COUNT(`date`) when my card is grouped by 'Day', I will divide by the number of…
  • If you need to do this on many cards and do not already have a fiscal calendar enabled you can reach out to our support team in order to create a fiscal calendar on cards that will do this for you without creating a beastmode. support.domo.com
  • Hello @odedbadt, This would be a great idea for a tile function in ETL. You can post this idea in our ideas exchange section. https://dojo.domo.com/t5/Ideas-Exchange/idb-p/Ideas There is a great article in the knowledge base that will walk you through how to do this currently. The article is written for avg and is not…
  • Hello @Adhitya, Value mapper would not be the best thing in this specific example. In Magic ETL the best thing to do is to create a filter for each value and then add constants. For example Data -- > (filter column) filter for when `column` contains 'ball' --> (Add constants) Add a column with the text 'Ball'. --> You…
  • Hello All, Here is a great article in the knowledge base that has the same information. http://knowledge.domo.com?cid=datediff
  • Hello @arav, There is a great article that I used to help me do this in the past. Here is a link: https://www.datascience.com/blog/introduction-to-forecasting-with-arima-in-r-learn-data-science-tutorials Cheers!
  • Hello @user008709, In the navigate function https://developer.domo.com/docs/dev-studio-references/domo-js#domo.navigate it is designed to navigate to a page within the Domo instance. For example, if you wanted to navigate to someone's profile it would be "domo.navigate('/profile/3234', true);" To add a hyperlink into your…
  • Hello @canio, There are a lot of wonderful sales oriented apps that can be found in the app store. I recommend taking a look to see if you can find one that works well with what you are trying to achieve. Cheers! 
  • Hello All, I wanted to provide a little insight into why Domo will give you an error when your Left table contains many duplicates. ETL is a very easy-to-use tool and makes doing joins very simple. We found that many people were making large cartesian joins because of how quick and easy it was to use. Because a left join…
  • Hello, Looking at the new set of screenshots it appears that something else may be occurring. Some of the notification settings are designed for Buzz. Looking at your screenshots I do not see any of the options for Buzz in the screenshots. Do you know if your company has had Buzz Chat disabled? If they have this would be…
  • Hello @Domofied and @Tomo, The reason why your screenshots are different is because of the version of domo you are on. The option is still present in the notification settings. It just has a new location. The option should either be above or below your notification settings. Cheers!
  • @woganmay, I apologize I should have noticed that. Not only was it mentioned int your subject line, but the call you are making is for SDK. I apologize for the miss communication. Try using: /data/v1/dataset/data