b_rad Contributor

@ellibot, By any chance, have you also figured out how to add new values to text variables using code engine? Thanks.

Thanks a lot @ellibot . That really helps. Appreciate your help in this.

@ellibot , Can you share the code which updates the date variable either here or in the Domo community instance? I was able to follow your video till the part where we are able to see the variable "expression" value. I cannot replicate on how you actually went and updated that value in your code. I believe it'll be helpful…

Thanks @MarkSnodgrass . As I was reviewing at my calculation, what you have shown did cross my mind. I agree this is even slicker and better.. :) I am going to accept that as the answer.

Its not entirely clear what your requirement is….so my solution could be totally off. You can enable the Totals in the table chart, and for the metrics for which you do not want the total you can use the "Hide Total" option for the columns for which you dont need the totals displayed.

My recommendation will be to do this in Magic ETL. Otherwise you might want to refer this and see if it works for you. https://domo-support.domo.com/s/article/360043430133?language=en_US

While I am waiting for Domo to respond. I created my own calculation do this. I did it as multi-step calculation, so that its clear and not confusing. I tried it out with various dates and it seems to produce accurate results. However, I would really appreciate if some of you try this yourself and confirm that this is…

I've submitted the ticket. Will update here with how it goes.

Domo does seem to have the option in DATEDIFF. Please see the full function description that I see in MagicETL for the DATEDIFF function. DATEDIFF([unit,]expr1,expr2)Returns the difference between two dates or timestamps. DATEDIFF has two forms: One with only two arguments (omitting the unit) called the "MySQL form", and…

Thanks Mark for your response. However, I dont want to use PERIOD_DIFFas its not accurate. For example, if I want to find the months between two dates '2025-02-11' and '2025-01-23', the DATEDIFF with the "month" option will give me the accurate answer of 0. PERIOD_DIFF will give me 1, which is not correct. Domo seems to…

Devon, Thanks for your response but I dont believe what you mentioned is the case. I am using valid columns and actually the formula tile gives an error when I run the ETL or try to "Preview" it even with hardcoded dates. For some reason, its not liking the MONTH parameter in the DATEDIFF function during the Run process.

Wow!! That's amazing. Can you please post the actual script as a text? It'll be helpful as I am not a programmer.

Can you share a screenshot? I dont understand what you mean.

Strongly agree. Not only for COUNT but for other aggregations like SUM as well. Its a pain to create Beast Mode fields just to do DISTINCT. Not sure why this is not there yet.

This is the facebook connector you need to use. https://everydayhealth.domo.com/appstore/connectors/com.domo.connector.facebook.beta The connector gives you option to pull in different Reports but I think the "Complete Page Insights" report should give you page views, impressions, organic, paid, etc.

This is how you do it… CASE WHEN (Contractor completion Date >= CURRENT_DATE()) THEN ('Digitisation') END Please note that Domo uses the time zone that's setup in your Admin console. I think the default is UTC.

I think you can set up a custom alert message… See this tutorial.

@hunter_brown if you using mathematical functions in beast mode, its advisable to aggregate* the columns in the calculation. *: The aggregation function depends on what you are trying to calculate.

A user can set their default landing page under their user settings. There is a "Landing Page" option under the General tab.

I agree it would be ideal to have readable email address but then it'll be very hard for Domo to make sure that each email connector dataset uses unique email address.

Signed up. Thanks for the opportunity. Cant wait to play with the App Studio.

I think the "BETWEEN" function is meant for the formula tile in MagicETL. That's why it probably shows up as a auto completion in the analyzer. I agree that Domo should clean up the auto completion and show only functions that work in Analyzer beast modes.

Domo AI Domo App Studio Domostats Workflow Domobricks Data Science

Who won the prize for the July community webinar? @eddiesmall said it'll be based on the profile updates.

I think your beast mode calculation should be as below. (SUM(`Sales Price`) - SUM(`Actual Cost`))/SUM(`Sales Price`) Try and let us know.

Done during the community webinar last week. Didnt see this post till now. :)

Thank you both @marcel_luthi & @ArborRose . Appreciate your help. The html table worked and I also had errors with my double quotes.

Wow!! That's an awesome feature. Thanks a lot for sharing it. This is going to make my life so much easier. :)

@MarkSnodgrass I got that part. I am more curious on how you got that code block for an ETL in the first place. I always end up in situations where I have to replicate an existing ETL and make a version of that ETL with modifications for another project. I use the copy ETL feature but I dont like the fact that it creates…

The email is indeed a great idea!! This is the beast mode calculation I am trying to replicate (see below). (SUM(metric1) over(partition by dimension1,dimension2,dimension3) ) * (sum(metric2)/SUM(metric2) over(partition by `dimension1,dimension2,dimension3))