SaloniShah Member

Thank you so much!

Alright, thank you so much for all your time! 😀

Got it. But why it doesn't do anything when I try to do both instances in the same tile(picture1)? Do you think there's any mistake in the 1st picture? I can validate the formula but output doesn't change at all after running it.

@MarkSnodgrass I tried your Include Exclude Way but when I add both instances in one Formula tile then it doesn't change anything. (picture1) If I separate both the instances in two different tiles, only the second instance(END user instance) gets implemented and the 1st tile formula gets negated. (picture2) Can you help…

Thank you so much!😁

Yes this worked! Thank you so much! 😀 I also liked your idea of Include Exclude. For that I'll have to create a new column and the value will be needed to be INCLUDE & EXCLUDE based on these formulas, correct? Can I add multiple instances in 1 formula tile or each instance will need a different tile?

Thank you. But this might be confusing for other people using DOMO occasionally to check on the data. I came up with the following formula & its working but I can't include multiple company names for the 2nd instance i asked. (Customer Type != 'END') OR (Customer Type = 'END' AND Bill-To Customer Name= 'A') AND (Customer…

Thanks @Jones01 & @MarkSnodgrass I used the STR_to_Date function and it worked fine.

@Jones01 what formula should I use to Cast it into date?

I recreated the connector and it still shows duplicates. I would try creating a ticket for support. Thank you for your help.

@RobSomers I just noticed. But I did check my dataset its getting replaced & not Appended. Why would it create duplicates ?

Hey @MichelleH , thanks for your response. I did remove the sorting. Still, I see these duplicates. What else can the issue be?

Hello @jaeW_at_Onyx , thanks for responding. My data is set to Replace. Duplicates is definitely not the issue. I'm attaching screenshots where in the Data tab I see single rows but when we go to visualize tab we see it duplicated. Example- 305 likes in May 2022.

Can someone please elaborate on this? I still can't find a way to remove duplicate rows. Thanks in advance.

Thankyou so much for your help!😀

I thought so. Thanks for confirming it for me. If I use MagicETL, is it going to be a manual process every time? Can it be updated automatically when the API pulls new data every day with the respective social media platforms?