DataMaven Coach

We need 'Contains' so badly! None of the workarounds work for the use cases I encounter the most.

@cadellfalconer - This is something that should be readily available - probably as a DomoStats Dataset, just like Users and Groups are. I would assume the endpoint has to already exist, since the data populates the org chart UI in Domo. And…of course…it would be brill if this could be used in PDP so that access could be…

It may be helpful to see what that hover looks like and where on the page it is. From what I am gathering, it's on the page, rather than the card, otherwise I would think it may be the card interaction settings. But if it's an app, it may still be that. There are so many places where interactions can be set.

@MichelleH said what I was going to say. It can't handle aggregates of aggregates. I find that putting the sum outside the case logic often solves this issue. Think of your case statement as a filter, and then aggregate the results. I also recommend breaking it apart and reviewing the results of each portion of the beast…

Hi @newbie123 - It's a best practice to only build cards off of datasets which have been through a dataflow, however, I understand that under the new consumption model, that has consequences. So - If we must be building cards off of raw datasets, here's a beast mode that may help you: Date(`Date`) If that doesn't work, you…

Should the Plan be the series instead?

CONCAT('$',`Your_Column`,'B') Though I like Colemen's solution much better. If you use mine instead, please also mark his as a solution, as it's solid.

We have been asking for this quite noisily for YEARS! Some day…SOME DAY! @BenSchein

In case you want to use your beast mode: COUNTDISTINCT(CASE WHEN Reporting Date = '31 December 2023' THEN Client Entity ID END) Obviously, that's not exactly it, given relative dates, etc, but I wanted to give you the order for that type of beast mode in case it helps you.

It's the double sum conundrum. lol

I agree with nulls being the issue, but I would do it in the dataflow. 😉

Can you give a small example of what you have and then make a scenario of what you would want the functionality to be? Also - what is your end-user actually doing? Is this for an app? Is this maybe a use case for Variables? If I am understanding the use case well enough, I think it might be a time to use Variables…

@vaco - There are a lot of things that are no longer available with GA4 because of decisions Google made. Most are related to privacy in a roundabout sort of way. You'll find things like demographics and geo data to be lacking, as well as anything else which has to require the user to agree to being tracked. Some, like the…

@mmisky87 - Thank you for marking as a solution!

@deona720 - Feedback on the Dataflow - Is there a reason you are using so many append tiles? I strongly recommend appending all of them in one append tile. This will not only be more efficient, but will allow you to easily review them all at once for any field conflicts. Additional recommendation - Name each of those…

I recommend adding all of the fields which are used in your beast mode into your table and scan through to see where the issue is. You can also take out the second WHEN statement. It should not have an impact, but may make things easier to review. Have you checked what Mark suggested? That is something that has come up…

If your recursive is set up properly, #4 should not be a factor. Then, you can simply have it run when the dataset updates. If the wrong data is sent, it should self-correct when the correct data comes through. If there aspect of the data or setup that make this not the case, please provide details. If there is an issue…

Total Users - I have not gotten accurate results for Total Users, no matter how I try. Sessions and Engagement - I will provide screenshots below of the settings I used. If I recall correctly, these are not necessarily accurate when rolled up to the total, but when filters are applied, they are generally quite close, if…

What issues are you having with the data? The API Endpoints for GA4 behave MUCH differently from GA3. It can be a nightmare. Rather…It has been a nightmare…to get data accurately pulling. Both dimensions and metrics conflict and result in data omission. Feel free to reach out if you need help. Domo may not be able to help…

@ArborRose - What is making you have to convert the times? Are the API's telling Domo what time zone they are in? If so, perhaps you can change the format so that time zone is in a separate column? As long as the data is coming into Domo in your desired time zone, no conversion should be necessary. The only exception I…

Hi @KristinDavis - I just finished an extensive project getting GA4 data to come in even remotely accurately. There are SO MANY nuances. For the User Counts, you are correct that if you don't want to double count users for the period, you have to have pulls by each desired grain. This is because all of the data is…

How about if it's a dashboard setting? I think that would meet in the middle for everyone. I see the use cases for both defaults, and I crave both defaults at different times, depending on the style and audience of a particular dashboard! 🤔 It could be something like Display Mode, but read as "Default Card Interaction":

@mmisky87 - Are you trying to get data from Domo to Excel or from Excel to Domo? I am thinking you are trying to get data from Domo into Excel, based on your screenshot. It seems as though you may need to use the new Office Plug-in to achieve this. It can be confusing with all the legacy tools, but the newest one does a…

Thanks @GrantStowell! I've been working more directly with Domo and with top contributors here, but I miss that direct connection in the community forum. I have also learned and seen evidence that under Ben's leadership, Product is looking at the ideas a lot more, so I will have to get my lists documented here!

@ST_-Superman-_ - I think he is really telling us that users are not able to duplicate the cards if they are locked. It's just got too much extra information.

What have you found to be missing? The information on dataset views is in the datasets dataset. The Import type is dataset-view. Anything downstream should follow the same path that datasets do. There is also a new additional dataset with the view's input dataset listed.

If you change your company time zone to UTC, you will be all set. That will simply mean that dates and times in your data will not be converted unless you convert them.

We should also be able to choose an existing card to insert into the drill path. Ohhh - the time that would save!

CASE WHEN 'column a'= '1' THEN ('column c'/('column b' *1000)) END This seems to belong in the question section, rather than the ideas exchange.

@Byboth - Michelle is spot-on. Have you tried to create any dataflows yet? The SQL option is quite prominent, so I am thinking you are just looking at documentation, perhaps?