mberkeley Contributor

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!

Thanks for the quick response. The problem I have with using filter cards is the size of the text lists that are being filtered. The text filter cards don't give me an easy view like the page filters. The option that I would really like to see is a per dashboard/card interaction option to say 'ignore filters' and let the…