b_rad Contributor

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…

Hi GrantSmith, Thanks a lot for your reply. Now I am able to pass multiple fields as filters to the linked page. However, like you had mentioned, this feature works only in HTML table (i was not able to get it to work in the Mega table). So basically its like each row has only one filter value for Opportunity and Account…

What Chart objects can be used for Page Analyzer Links to work? Also anyone tried/ or made it work for multiple fields with multiple values ? Thanks in advance.

Yes. Nothing changed. It just stopped working. Like I said the filter works when I choose dates from the calendar but only the presets dont work.