mberkeley Contributor

This is definitely a DOMO bug. The ETL has been running successfully for several months without issue. I have an open ticket at 2 levels of escalation within DOMO.

self-solved: I removed the Escape Character setting and the data imported.

It is a mega table. I need to be able to scroll the table in the dashboard view so I can use the table to filter other cards.

@david_cunningham That did it. It would help if I used the right chart type 😁

@david_cunningham Thanks. I am able to get the values for the dates and do the math as you suggested. What I can't figure out is how to use the multivalue card to show the Current Value and then the % change. like this:

@Jones01 Thanks for confirming. The feature was built specifically for us. I'm glad they made it accessible to everyone via a feature switch.

@Luka_V I agree, I would like to have the option as well, but I did get what I needed and haven't pursued this any further.

@Jones01 This was originally built for us. I don't know how far Domo has gone in making this an easily turned-on option for other tenants. Please let others in this thread know if you are successful!

@Jones01 That is correct. I am able to receive card-based scheduled reports as an .XLSX file, keeping all of the UTF-8 characters. I don't have an option to choose XLSX or CSV. It sends an XLSX file for all card-based scheduled reports.

I have this working in my account, but I don't have a choice between CSV and Excel. Excel is automatically used. I believe this is a Domo-managed configuration change for your tenant.

Thanks, Grant. The solution worked.

I need to spend more time looking at the Window function to see if understand how to do this. Thanks for giving me direction.

I've added this as a suggestion in the Ideas Exchange. Please vote for it if this would be useful to you. https://dojo.domo.com/main/discussion/55399/scheduled-report-excel-attachement#latest

Way too big for a cartesian join. (18M records x 2.9M records)!

I can't believe that works, but it does! thanks.

I also noticed that the REGEXP_REPLACE() function isn't allowing the 'g' flag, saying that there is an error that REGEXP_LIKE doesn't recognize that flag.

I like the MySQL version more, but have never written SQL ETL, so I worked with the Magic ETL version. It does exactly what I needed. Thank you!

This is the only data element that has multiple rows in the data everything else is 1 row per 'user'. I was hoping to be able to do this during the import process. It's a pretty standard SQL function. If I can't make it work during import, the next step is to aggregate after import. It looks I can do it in the 'Add…

I've made the request to my CSM. I agree this is needed.

I agree, this is a needed feature.

@GrantSmith I am trying to get access to the DataSet View beta now. Hopefully, that will allow me to do this effectively. thanks!

@rahul93 Your solution would work if I always wanted to compare Company A to the community, however, I need to be able to compare any company against the community when filtered from a story dashboard.

Unfortunately not, these are actually web analytics where there are several values for page categories and the value for ‘Time On Page’ that i am trying to average. So I am looking for the average time on page, ignoring all of the extra rows with category info.

I am really looking for AVG('time') for each distinct (or avg) time per customer/timestamp)

A customer could have different values at different times. One of the other values that would be used to uniquely identify a row would be a timestamp.

BTW. My original version of this works in the original ETL tools, just not in ETL2.

The answer above worked. Thank you.

Thanks. Trying this now.

The inability to scroll is a deal-breaker for this table. Thanks for the info though!

The inability to scroll is a deal-breaker for this table. Thanks for the info though!