DashboardDude Coach

@virank I can help you here as I do marketing. Okay so you can do a couple things: You can connect Mailchimp or Constant Contact or Klaviyo, etc to Domo via connectors to get analytics on which campaigns have the best CTOR (Click to Open Rate: Unique Clicks to Unique Opens) You can also connect SEMRush to get insights into…

@AmyMcC I can help. I was trying to make you a video like I normally do for people, but running into internet issues this week. Okay so when you pull a report, like campaign, you have to go to metrics and pull cost_micros. However you then have to divide that by 100000 because Google's API has costs like this and not in…

@RanjitR Here you go https://www.loom.com/share/94234f8644a84e1886b6d883e463aecd

Hi @RanjitR , @GrantSmith is right in the approach. I think the question I have is do you always want it to be a rolling 8 weeks or do you need that to change?

@lauramiddleton I made you a video answer: Hope this helps

Hi @PJG , I think I understand but still a little vague. I think I would do a count distinct in the ETL that you can then use to do your sum or count.

@jbaum788 Thanks! Happy to help! Send me any ideas you'd like to see.

@damen I would just make a Beast mode calculated field where you round everything to 2 decimal places after your upload. That formula is ROUND(`P&l Payment Amont`,2)

@Anna_Otake Yep. Just change your Value Format to Percentage. I recreated to show you.

Hi @PJG Anyway you can share a screenshot of the entire analyzer for us to see? It will be easier to understand

@LearningNinja can you share a screenshot of the entire Analyzer for the card please?

@robinmathew131 Domo also has a calendar in Domo Dimensions with a isHoliday flag and a isWeekend Flag. So you can use that too to find working days to get to Net Working Days

@Jarren Glad you figured it out!!

@sbutterbrodt I think you uncovered something. I just tried too and get the same results. I would suggest emailing Chris Wright at Domo and showing your example: chris.Wright@domo.com

@Jarren Thanks. Truthfully, this is a bit difficult to help without seeing context. I'm happy to give 30 min if you are free and willing to share your screen, but if not I hope you can figure out what's going on: Feel free to book 30 for tomorrow if you want to:

@Jarren and can you share a screen shot of what Totals looks like under chart properties?

Hi @Zel , I hope I can help. Here is where I have some SQL formulas to help: If you look at "Round dates to previous monday" you can see this formula: Date-weekday(Date -1)+1 (if doing in a beast mode). Let me know if that helps

@david_cunningham I think @SwapnaE for instance wants the goal line (orange horizontal lines) to change dependent on like if someone new is chosen in a filter or something. @SwapnaE, unfortunately that "goal" is hard coded. Your better bet is to use a different chart like bullet where now you can add in a goal per person…

@Jarren trying to also help here. Just want to confirm that the columns are numeric. When you add columns to the top of analyzer where it says columns are they green or blue? A screenshot would help too.

Hi @Armin , I'm trying to answer this one too, but struggling because I don't really understand the problem. If possible, can you show a screenshot of what you are seeing and why it's wrong? Like your formula works if you only show Customer ID 1 in a table with status, but won't work if you show customer ID 2 because the…

Hi @Armin , So when you run this, what is the result you see and why is it incorrect?

@Zel Hope this helps:

@pauljames Here you go:

Thanks all!! So grateful and really love the community…except when it comes time to Demo Slam…then it's a free for all! Ready to see you all at Domopalooza!

I have gone from Gandolf the Grey to Gandolf the White!

@pauljames You may need to put a filter before this alter step to filter out rows that are text before you do the alter. So you probably need to first get a list of all unique values and see if there are a lot of text values

Hi @zfeinberg , Not sure if this will help, but I hope it does:

Hi @zfeinberg , So all of these numbers divided by month 0?

@hecl3 Here's my video on how to do this using a CAST function:

I need some popcorn when I watch @GrantSmith and @MarkSnodgrass going to battle over these points.