b_rad Contributor

@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.