PEAKS_valleys Member

Hey @scboyce - I'm assuming that the data types being used are because Domo is making sure to accommodate for different length numeric and string values (storage) and for efficiency reasons. For example, double floating point numbers have larger ranges than Decimal numbers and Double is the most efficient floating-point…

Hey @scboyce - Is this something you're working through in Workbench or as a DataFusion? These definitions are from the Help Center - Combining DataSets Using DataFusion * LONG stores numbers as numeric values, including decimal, fractional, and whole numbers. * DOUBLE stores double-precision floating point number values.…

Hey @jkb - It looks like the transparency color option isn't available to use with stacked bar + line or other chart types beyone the vertical bar and vertical stacked bar chart types. Changing the Default Colors in Your Chart is probably what you are referencing in your post but take a look at point 3 under "To change…

Hey @abaig - Take a look at this other post - https://dojo.domo.com/t5/Card-Building/Waterfall-Graph-ordering/td-p/15063 There is some great documentation in the help center for this use case, take a look at the force sort order section. Hope this helps! 

Hey @jkb - The minimum interval for dataset refreshes is 15 min. Take a look at the Adding a Dataset Using a Data Connector in the help center. This same interval applies to Workbench 4 jobs, take a look here. Hope this helps! 

Hey @razmik - When you duplicate a card the alerts assocaited with that card don't transfer. But, if you copy the card to a different page the alert will transfer as part of the copy. Keep in mind that when you copy any changes made to a copy of a card are also made to all other copies. Could you provide a little more…

Hey @Dpritykin - There are a couple of ways that you can view which alers users have setup, are following and which cards alerts are based on. You can manage custom alerts in two different locations—in the card Details view and in the Alert Center. In a Details view you can view and manage all alerts for an individual…

Hey @kelly - How are you joining? Are you using the Magic ETL or MySQL dataflow? 

@angelsinha - Ok, great. Appologies if i'm not understanding or maybe it's a difference in Adobe Analytics configurations but what I'm able to do is use my report suite ID located in the Admin section -> Report Suites. In the example below, I'm using the desktop production site ID to get a list of all the elemets…

Hi @razmik - You have a couple of options depending on whether you're trying to create a copy or a duplicate. You can duplicate a card to create a new instance of that card that can be manipulated separately from the original card. This is different from the copy functionality because cards that are copied are still…

Hey @angelsinha - Have you confirmend via the Adobe API explorer that your report ID is actually called "language"? You may have already done this but just wanted to reiterate. For example there is a report in my suite called 'Audio Support' but the "id" is "mobileaudiosupport". If you use the AA API explorer you can…

@angelsinha Have you tried to just run {"top":50,"id":"language"} to see if it works? Is the "name" in your request actually the "classification" ?

Hey @angelsinha - By default, AA only returns the top 10 parts within the element. The 'Additional Element Information' section is based on JSON, so your query would look somehting like: {"top":50,id:"lasttouchchannel"} As a note, the JSON in the 'Additional Element Information' section takes the place of checking the box…

Hey @VikkiChuChu - What you can do is use publications to send and manage slideshows of your cards. Publications let others view the slides outside of Domo. When you publish a Publication, Domo creates a URL for accessing the Publication on the Web. You can send an email containing the URL link to others, inviting them to…

Hey @CMartinaglia - You can manually set the sort order with a Beast Mode calculation, something similar to: CASE WHEN `Dimension` = '2015 Sales' THEN 1 WHEN `Dimension` = 'Price' THEN 2 WHEN `Dimension` = 'Mix' THEN 3 WHEN `Dimension` = 'Quantity' THEN 4 WHEN `Dimension` = '2016 Sales' THEN 5 ELSE 0 END Take a look at the…

Sweet, glad you got this squared away!

Hey Chris - Maybe I'm missing exactly what you're trying to do but can you create the final table outside of Domo and then import? You could use MySQL or PostreSQL interface to run the join of the datasets. Or, you could import both datasets and join them using a MySQL dataflow in Domo. - Aaron

Hey @northshorehiker - I don't think that you can pass a table variable as in input, it doesn't work like a create table function. Have you tried using the transforms available in workbench to get the dates you're looking for? Or, have you tried importing the table and creating a MySQL dataflow within Domo? The workbench…

Hey @angelsinha - Take a look at this article in the knowledge center, hope it helps! https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Transforming_Data_Using_Beast_Mode/04Sample_Beast_Mode_Calculations

Hi @Reema - Can you provide a little more detail around what you're trying to accomplish? 

@zaif_chew 1. I replicated your webform and used this in the MySQL dataflow. 2. I used the CONVERT function to change the data type to datetime and then renamed the column to `launch_date2` 3. Just showing that the `launch_date` field was changed to a date in `launch_date2` Hope this helps! 

Hey @AritraChaudhuri - How are you trying to import these datasets?

Hey @Z_M - Webforms support copy and paste functions but I don't think there is a way to copy a dataset like you could in MySql with CREATE TABLE and LIKE functions. Since the template & hearders are all standard have you tried just copying and pasting to a new webform? Let me know if this helps!

@WaitYes - There are a couple of things you can do. Just announced in the July 2016 release notes is something called Personalized Data Permissions (PDP) check it out here . You can also limit access by managing the user Access Rights in the Admin Console, ensuring cards and datasets are only editable & shared by Admins,…

@zaif_chew - have you tried mm/dd/yyyy hh:mm:ss ? I just created a webform using this date time format. As a QA I was able to use a beast mode to remove the time component. Hope this helps!