kim_barragan0126 Member

Perfect! Thank you. I also used it to omit End Dates in the past. I appreciate the learning! CASE WHEN ActualEndDate< NOW() THEN 1 ELSE 0 END

Thank you! But I am getting an error.

thank you!

Thank you! The command worked great.

Thanks for your help. I am good now!

I believe that filter there because I am adding the PDP to see what the user will see.

Thank you. I am going to play around with it this afternoon, but will let you know if I need further help. What is strange is the card is correct, but if I enlarge the card, the number changes and the PDP seems to not work.

thank you!

Thank you all! I have fixed the issue, not sure how I fixed it, but it is good now. I will go back now and see what steps worked. I appreciate all the help as it did help me determine what the issue was, and how to research it. Thank you!

It shows Date in my data, but string when I run it through ETL. I tried using a Alter tile and change to Date, but that causes an error. I also tried changing the file itself to text and date and both issues. Maybe I need support ticket?

I have five date fields so I am not sure the one that has the issue. All the dates are noted as the below. Is there a way to determine which field is causing the issue?

I am all good - thank you for asking!

Thank you. Good point. I also need a way to count how many candidates or matches, and that is why i was using the Distinct Count. Appreciate your help!

Yes. I will try it again. I appreciate the help!

The COUNT DISTINCT is not removing the duplicates. And if I remove dupes in ETL, i am losing the $ associated to the match ID's. The match ID's show up weekly, and I just want to count then once each week. Maybe I am not able to do so.

Perfect! Thank you!

Thank you very much! Perfect!

Thank you!

Thank you for the responses! I was able to create the below Beast Mode which solved my issue. SUM(MAX(Fee) FIXED (by Position ID))

Well, that was too easy! I should have known that - thank you!

The data set updates when it comes through a email connector. I want to add the "Tags" column, but it doesn't show. I see that on my Append Tile, the Weekly Funnel has the below.

Worked great! I appreciate learning new tricks!

Thank you. I am getting a calculation error. I have tried all the below. UPPER(SQUASH_WHITESPACE(companyname)) UPPER(SQUASH_WHITESPACE(`company name`))

Thank you! I will try this out.

Perfect! Thank you for teaching me something new. Appreciate the simplicity!

Thank you. It doesn't seem I can keep my format that I am using with the Pivot table if I change to the HTML table.

Hello, Thank you for the feedback. The data set is coming from one report that was uploaded. And the report has numbers in it such as the below, but Domo is showing a blank cell.

Yes, it represents a negative number. Would the below fix this in the magic etl? Using a string operation.

You are right. I ran it several hours ago, and it was still running. Must have been stuck. I canceled that one and ran it again. All good here now. Thank you!

Thank you! That worked.