user027926 Member

Solved my own issue with a Dynamic Unpivot

Thanks @MarkSnodgrass . The card level won't work for this, but thanks for the mention. The issue that I'm having (if I understand your suggestion correctly) is that the lag function is consistent to one line. I need the lag function to be conditional, as something it needs to go back a few rows (until it hits a row with a…

Thanks @MarkSnodgrass -- this is the right logic (only I'd change the flags being equal to them summing to less than or equal to 1, to include the first value as well). Where I keep getting is stuck is how to do a previous function (or lag) within the function tile. It doesn't seem like its supported. (That would be for…

Thanks @MarkSnodgrass -- in the end, it was, as you had suggested a spelling error (which was not in my formula but was being outputted from the CRM automatically). Thank you!!

Thanks @MarkSnodgrass -- still didn't work (I changed the Text Formatting tile to be all UPPER instead of first letter cap)

Yes, I was certain that it is exactly like that-- did a Text edit as the tile before that and chose first letter Capital. I'll make it all UPPER and see if it helps. Thanks

I plugged this in Google translate, so apologies for writing in English. It translated as: "Is there a way to create a stacked bar chart that compares the numbers for the same month for each year, as in the attached image? I tried the graph type "Set + Stacked Column Graph", but I could only specify the series to be…

If I'm understanding your issue correctly, the issue is that you want to compute a beast mode of a beast mode. My recommendation is to use Magic ETL for (at least) your first computation and then you can compute the second formula either in another Magic ETL tile or in a Beast Mode. If you use the formula tile in Magic ETL…

We use Monday.com and while we don't automate, a workaround that we use is Monday to Google Sheets (which are data sources in Domo). There is a slight manual process, but especially with a Zapier connector, its pretty smooth.

@MarkSnodgrass . Thanks. I tried that and I also tried changing all nulls to zeroes in the ETL. Also tried doubling up on the ETL and making a case within a case. For some reason, it's not changing. All other ideas are welcome :) Thanks!

@MarkSnodgrass -- thanks, that's what I tried first. No success

@GrantSmith --yes, that's what I did, but because each column is just a COUNT, the rows where the count=zero are not showing

Thank you @GrantSmith ! This was really helpful and SUPER clear (and something that I've wanted to better understand for a while, so thank you!) Here's the catch-- the card is comprised of values that are all COUNTs. Meaning having a zero in a field won't change the fact that there are sometimes just zero counts and…

Thanks! Agree about the oddity, which is why I'm a bit stumped. I tried it in https://ga-dev-tools.web.app/query-explorer/ and it does not run. Does this mean that its an API issue and something I can't overcome or just that I need a different version of GA? Any idea? Thanks!

@GrantSmith -- this is the exact custom report that I am trying to pull. I was limiting it to 90 days, just to that I could see if it works, not pulling. I'll look into GA360. Other tips? Thanks

Thanks for the replies! No error in Domo and I don't see anything in the settings that would indicate trouble. Weird that this is happening. Thanks!

I have a lot of other data in domo already. Is that an indicator that the settings are correct? If not, what should the settings be?

Gotcha. Thank you!

Thanks Mark! What then does limit preview rows to 1K, 10Km 20K etc. mean?

OK, so after a lot of Domo assistance, we have finally discovered the issue. In Domo Beta-- when you do a join, you can also select what you do with repeat columns. I did a right join, but mistakenly fixed the right columns by dropping them. This created a slew of nulls, as there were rows which no longer had my joining…

Thank you. It makes complete sense. Meaning-- the join data tile is reading 700K+. It just means that I need to find those missing rows elsewhere, as the output should be the higher number. Thank you!

Interesting-- so any idea why it is losing some? Here is a screen shot of a few steps back to give you a sense:

The other number was accurate. It was 700K going in (or it should have been) and the 400K was the outgoing. That's the only way that makes sense (I did a 2 sided join the tile before and then deducted the duplicates)

That was the previous step- when it went from 700k to 400k. This is just sliding that data to the output.

Thank you all! Really helpful!

I realize now that I can just edit the text in 'Text Formatting' to include just numbers. Thank you for your help!

Thanks Superman! I've learned a lot, but still learning. Which function in magic ETL would allow me to enter a regex formula? (I don't have advanced options). Thanks!