b_rad Contributor

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))

@MarkSnodgrass I am curious how to get the code to replicate an ETL. I could really use that. Thanks, Bharath.

Hi @Salmas I dont think you can do it directly in the chart. You have to prepare your data in the ETL process in such a way you have the current day and prev day values in the same row. Domo doesnt seem to have a function that would allow us to compare values directly in the chart. Maybe this could be a feature request. I…

Hi Jessica, Your beast mode calculation should look like this.... CONCAT('<a href=''https://xxxx.domo.com/page/xxxxxx?pfilters=[' ,'{"column”:”A”,”datasourceid":"xxxxxx”,”dataType":"string","operand":"IN","values":["' ,`A` ,'"]},' ,'{"column”:”B”,”datasourceid”:”xxxxx”,”dataType":"string","operand":"IN","values":["' ,`B`…

I tried it already but for whatever reason, it doesn't give me a date format option for the date field. It only gives Number, Currency, Percentage option. See screenshot below.

No. Its a macro that Domo allows to you in the "Additional Text Options". See screenshot below.

@GrantSmith Actually you are right. The only other thing I had do was to add the date field (x-axis field) first to the sort and then add the sum(metric) sort. Thanks a lot!!

@user084115 your recommendation wont work because of two things 1) I want to rank on impressions but my chart is going to show a different metric "position". 2) The ranking should be for the "query" dimension but date would be on the x-axis. I also reach out to Domo support and they actually echoed @MarkSnodgrass and…

@GrantSmith , Thanks a lot for letting me know about this alpha feature. Will try to get it enabled and see if it performs as intended.

@GrantSmith , Thanks a lot for letting me know about this alpha feature. Will try to get it enabled and see if it performs as intended.

Can you provide an example? Since I can use only a html table, even if I aggregate and include the beast mode calculation as a column, each row still has only one value for each dimension in the filter. I think I am missing something.

Mark, Thanks a lot for the detailed answer. This is very helpful. Its a shame that a powerful BI tool like Domo doesn't have this feature even when a basic reporting tool like Data Studio has this functionality. I'll get the "Window function" enabled and also submit a new feature request through my CSM for this. Thanks…