swagner Contributor

It's been days… we looked at permissions and the feedback was there are no differences in the 5 files from that standpoint. I'll try with the CSV pull connector - thanks for the suggestion.

This is an old string, but wondering if anyone has solution for this issue. I am having this problem now with 2 or 5 connections. 3 of the files are available and are connected. The other 2, when I open the interface in the connector to select the file the are not showing up. Using the CSV Advanced connector, and have…

I would for sure use this capability if available. Would also be helpful on other user profile properties like, location, department, manager name, including my own defined properties. (Not PDP)

@Byboth I'd recommend reaching out to your CSM to have them find out for you. Please post the ultimate answer here in case others need the same.

@JasonAltenburg great idea! I have a testuser@domo.com account I use for this specific thing, but it's limited. Would be so much better if we could do as you describe.

@MattYoung I don't know of a way to detect the user property and highlight the way you're describing above. Maybe someone else might - but I am very interested in this and would use it in my instance. If you don't get an answer on this ask please submit this in the idea exchange. I'd for sure support your idea.

@Byboth I see this in my grants: Do you not?

@vibhusharma2210 yes, I am doing some things like that with snapshots of data in similar windows from ETL. Also approaching as partitions in ETL (Current Month, Current Year, Prior Years) and appending all of those back together in a dataset view (logical storage). The tools allow for a lot of approaches. You should also…

@JasonNgaiGPT I would use this like crazy!

@Prospero I would use this often!

@btilley agree!

@vibhusharma2210 the short answer is yes you can build a data warehouse in Domo. Here is the knowledge base article on this topic: As far as limitations/challenges it really depends on your use case, how much you want to do within the Domo instance vs before passing your data into Domo, etc. Really an architecture strategy…

@afieweger have you tried adding a card filter with an aggregation?

@dkonig Can you include a screen shot of that total row contents so we can "see" what you're dealing with?

@colemenwilson totally agree! This would make it so much more intuitive for my end users who are sending data via this connector.

Posted in the Idea exchange here:

@GrantSmith thank you sir!

I figured it out… here is the SQL for anyone else trying to do the same: STR_TO_DATE(CONCAT(DATE_FORMAT(Date Updated, '%b %e, %Y'), ' ', TIME_FORMAT(SEC_TO_TIME(Time Updated), '%h:%i:%s %p')), '%b %e, %Y %h:%i:%s %p')

This doesn't work for me… frustrating…

@TheScotsman I have a similar need to pull Copper spot pricing… yfinance would be a viable source. Can you share python script and any other details of this pull please?

@pstrauss did you get this worked out? I have the same need. Thanks

@jaeW_at_Onyx found this post today, do you know if the feature you mentioned got released to production?

Couple of years down the road and I'm facing this same issue. CSV file I need is not in the root folder, rather down a few layers in subfolders. Any way to specify?

@GrantSmith thanks!

There will be filtering on the card (in analyzer) for the eCommerce transaction type. That would narrow the field down to customers who have ordered (all in the data) and customers who have ordered more than once.

Thanks @GrantSmith

@jaeW_at_Onyx thanks for the response! Much appreciated!

@Ashleigh thanks for the feedback. I will definitely do this as a work around, but still think it would be great if it was an included filter option. Have a great weekend!

@WizardOz what kind of issues are your users having? So far for me, once you get through the learning curve Dataset Views are a great tool. Opening up some great possibilities for my use case. Let me know if you'd like to have a call to discuss. Sometimes "customer to customer" is a good way to figure things out. Happy to…

@WizardOz probably worth contacting your CSM if this is an urgent problem. My experience so far with Dataset Views is that they are a bit temperamental and quirky. I'm also finding that there is a specific order in which you should do things. Doing any Group By steps last is something I try to do which has caused less…