levi_kim Member

App Studio

Hi @Mickey , This can be done via a Domo App and created as a card. You essentially create a CSV picklist filter. The card is then added as a Control on a dashboard where users can upload a CSV of desired attributes to look up and it will automatically filter. I don't have much more detail on the App itself as I am not the…

Hi Devon, the value mapper worked! I'm not sure why the formulas didn't work. Thank you for the tip!

Hi Grant, unfortunately I still got blanks for some reason. I tried Value Mapper and it worked. Thanks for the reccomendation though!

@DavidChurchman Ah, I think that's what was causing the issue! It wasn't the format necessarily but it was graphed by 'Year' which threw off the results. Thank you!

Hi @ggenovese , Yes it is. I should have clarified in the original post.

Hi @brycec , Thanks for your response. It was affecting all cards powered by the dataset. The issue has since fixed itself. It must've been a bug on Domo's end because we didn't change anything. I did try to look at the API response but didn't save the message :/ I will keep this in mind for next time since it's a helpful…

@DavidChurchman Thank you for sharing your BeastMode! It worked perfectly for me. Much appreciated.

@zaclingen_fwm , Great, I will give this a shot. Thanks!

Hi @zaclingen_fwm , Thanks for your response. Can you elaborate more on the search filter card and/or provide pictures? Your link takes me to your company's Domo domain which I cannot access.

Hi @DavidChurchman , Thanks for your response. Option A is what I'd like to see. I used the Append Rows tile in my Magic ETL but it's not working as expected. A lot of fields that should be populated were empty such as Item Number. For Append Rows tiles, I chose to include all columns. I think I might be missing a key…

Hi @ColemenWilson , Thanks for the quick reply. I will give it a shot but I don't think it's the best option due to the different structure in the datasets. Any other ideas?

Thanks @ColemenWilson ! This should be the solution I was looking for. Now I wait for the alert to trigger.

Thank you @Sean_Tully @MarkSnodgrass @GrantSmith ! Your answers are very insightful and helpful. I will definitely add them to my toolkit. I ended up using Mark's SPLIT_PART function as that was easiest and fit my criteria.

Hi @MichelleH , I wouldn't say new rows are added on a regular basis but I would like to track any changes whether that be new rows or changing quantities or prices which affect total value. I've never tried adding a relative date field to new rows. Do you have any resources that could help? Or any advice on tracking…

Hi @ColemenWilson , Thanks for your response. I tried that beastmode and applied it but it still displays Order Numbers that do not have UN Number. An example below: Null fields can be tricky sometimes with our datasets. We've had to use prompts such as When UN Number = '' and when length('UN Number') < 1 as well because…