eric_tetik Member

Hi @rgbuckley, The calculation below should do the trick: 'Efficiency' / AVG('Efficiency') Let me know how that goes Cheers, Eric

Hi @user11128, You should be able to achieve this by sorting by date field first, then sort by the series total using an aggregation on SUM/COUNT/AVG as per your requirement Cheers, Eric

Hi @rado98, A reason for that drop in run time could be because the dataset that is on the "right" of the join could have significantly less rows than on the left, thus bringing through less rows in total, less rows to process later in the ETL, etc. Have you noticed a drop in row count in the ETLs where you've changed from…

Hi @Peng, Can you share your Beast Mode calculation with us please? Also, are you certain that the date field that you're filtering on includes the time? Cheers, Eric

Hi @user095713, I'm not entirely sure if you can/cannot do what you want at the card level, however you should be able to do it in a SQL Transform. You could use your existing dataset as the input and do something along the lines of: SELECT *, (CASE WHEN `Revenue_Date` = DATE(DATE_ADD(`Revenue_Date`, interval -1 year))…

Hi @hamza_123, Other users (including myself) have also wanted to see a search bar feature in a filter card. There is a post in the Ideas Exchange which you can Like, support and follow. There is no dropdown option for filter cards at the moment. Cheers Eric

Hi @Ashleigh I've tried with and without sorting and neither get me closer to the intended effect. Decided to present the cards differently so no longer an issue, however if you (or anyone) have a solution it'll be great for future reference and other users Cheers Eric

Hi @hamza_123 , After Step 2 of what you outlined in your dataflow process, you could: 1) Add another SQL transform in the same SQL Dataflow with a where clause along the lines of: WHERE isObsolete = 0 OR dateCreated > DATEADD(Week, -2, dateCreated) This will only include rows that are not obsolete, or rows that are dated…

Hi Liz, Unfortunately Domo Beast Mode doesn't support all HTML tags and CSS attributes. font-style is one of them. You can find a list of supported tags and attributes in the Knowledge Base (Under HTML Table Tags you will see a bullet-point list of style attributes allowed). Cheers, Eric

Hi, This is assuming you want the current date and time: var date = new Date(); var year = date.getYear()+1900; var month = (date.getMonth() < 10)? '0' + date.getMonth() : date.getMonth(); var day = (date.getDate() < 10)? '0' + date.getDate() : date.getDate(); var hours = (date.getHours() < 10)? '0' + date.getHours() :…

Thanks for your response @Ashleigh I've already tried that and unfortunately it doesn't work. It does works in this simple form: However I can't separate the bars into series of "Organisation Type" like the image in the original post. At best, I just receive various versions of the above. The user in this question ran into…

Hi there, I'm sure you have already but I must ask - have you performed a Save & Close and viewed the card outside of the analyser? I've had multiple incidents myself where the HTML code would appear in the cell and would only have the intended affect outside of the analyser. If you could also send a snippet of your Beast…

Here's a little more formatting to get the result you need: var options = { weekday: 'short', year: 'numeric', month: 'short', day: 'numeric', hour: '2-digit', minute: '2-digit', second: '2-digit', hour12: false } today = new Date(); var date = today.toLocaleDateString("en-AU", options) + ' GMT'; // Replace period with…

Hi there, Just to get more context, is there something stopping you from using the text datatype for the relevant columns? If you can provide a screenshot of the data that would give us a better idea of what you're dealing with (if you do decide to provide a screenshot don't forget to censor any sensitive data!) Cheers,…

Hi there, If I understood you correctly, you're building a custom connector in Domo and need the current date in the format you specified in order to make an API call. You can do that using pure JavaScript with the code below: var options = { weekday: 'short', year: 'numeric', month: 'short', day: 'numeric', hour:…

Hi there, Can you please post a screenshot of your code so we can diagnose the issue. Another way of parsing JSON data is by using the JSON.parse() method. Examples below: var parsedData = JSON.parse(my_data); DOMO.log(parsedData.id) DOMO.log(parsedData.person.age) DOMO.log(parsedData.person["first-name"]) for(var i = 0; i…

Hi there, So I can better understand the structure of the data array, can you please paste the following two lines of code underneath var data = bills; and send through the response DOMO.log(data[0]); DOMO.log(data[1]); Make sure to cover up/draw over any sensitive information Cheers Eric

Hi there, If I've understood you correctly, you have some data stored in another platform (Oracle BI) and would like to bring that across to Domo by making calls to its API endpoints. You can create a custom connector in Domo and make calls to any API endpoints, assuming you have the authorization and authentication…

Hi YoDaMo, If I understood you correctly, you have users in Admin Settings > People that are showing up as inactive. As far as I know there is no way to "merge" accounts together. What are your intentions for merging the accounts? Do you want to replicate permissions/settings, copy across cards from the old account to the…

Hi DMJerry, You can export the job using the Export feature by going to More > Export, and then import it using More > Import. You can rename the job when importing This is in Version 5.0.7080.31479, not sure if it's available in previous versions Cheers Eric