Anna_Otake Member

I opened the card today and the beastmode is now working on the card. I'm not sure why it wasn't working last week, but I appreciate all of your input! Thank you!

Thank you @nmizzell for your help as well! Very detailed and helpful!

Thank you so much for the video @ColemenWilson ! I found your video very informative and easy to follow. This worked perfectly and I was able to create my card!

Hi @ColemenWilson Thank you for your help! The dataset is already appended (below is the screenshot) and essentially, I want to create a card that would be able to detect a campaign if they're named differently from both datasets. I'm not sure if my dataflow is incorrect or my beast mode is set up wrong.

Great observation @colemenwilson! Thank you for pointing that out, that was the issue!

@colemenwilson hmm weird! When I copy and paste it into this comment section, the minus sign goes away. But this is what I have which is the same equation that you provided for me. I copy and pasted yours but nothing changed.

Thanks @colemenwilson for your input! Totally my bad, I forgot to put the minus sign in the above description! I have this as my calculation now and it's still not working. ((sum(case when Fiscal Week Index=(Current Week Index-1) then Amount_Cost end)) (sum(case when Fiscal Week Index=(Current Week Index-2) then…

@MichelleH @DomoDork You two are awesome! That fixed it, thank you so much!

Hi @MichelleH, that worked perfectly! Thank you so much for your help! Another thing I want to tweak is that I'm trying to count the number of email types and not the number of emails sent per week. For example, this one campaign has 11 emails sent to this campaign but all other days except 5/29 have been sent twice in one…

Thank you so much for your help @michiko ! It worked :D I removed my SPLIT_PART(EmailName,'',LENGTH(EmailName) - LENGTH(REPLACE(EmailName,'','')) + 1) formula and applied your two formulas to my tile and it worked perfectly! I appreciate your help and thank you @GrantSmith ad @MarkSnodgrass for joining your brain on this…

Hmm seems like it didn't work. Before this formula tile, I have a Text Formatting tile to make everything into a lowercase, then a String Operations tile to trim some spaces, then a formula tile to identify the last end of the EmailName to name it 'Circ Value'. Do you have any idea why this formula is deleting some of the…

Thanks @GrantSmith but unfortunately, only one row came back with a numerical value, everything else is null :(

Thank you @GrantSmith and @MarkSnodgrass! @MarkSnodgrass, using your formula, I was able to get it pretty close but your formula is still catching anything that has a 'k' followed by a number. On top of this formula you provided, is there a solution to exclude all data that has any number of letters after the 'k'?

@GrantSmith this is a demo example that I made just to test things out but essentially, I want the output value to be something like 110,000, 20,000, etc. I want to extract the number + 'k' and then multiply or replace that k with 1000. This means I want to take out anything like 99kelly or 3karaokegirls or ask50people. I…

Hi @GrantSmith , thank you for your help! I appreciate it. Unfortunately, that formula didn't work for both the regex and the formula tile. Do you have any other recommendations?

Hi Andrew, I submitted this same request in March so I'd appreciate it if you can upvote my post. Thanks!

Hi Matt, thank you for your comment and I look forward to when this solution is out to the public!