PodiumMason Contributor

@IVG Do you know SQL and have access to dataflows? I can help you there if you do. Otherwise, Domo support is always available to help. 

Hi @rahul93, You can start here https://developer.domo.com/ That will give you access to the SDK and documentation, which will allow you to create your own apps for Domo. Let me know if this is helpful or if you have any additional questions.

@IVG That's exactly right. The only way I know to line up the values is by aggregation but it seems the comparitive gauge card doesn't support beast mode level aggregation. I would see if @domosupport on buzz or support@domo.com has any suggestions. It's possible someone else on the board may have an idea on how to solve…

@user00421 I figured out the problem with my logic, the bad news is that the comparitive gauge won't accept the fix. The date alignment column is correct, the current value needs to be a beast mode: SUM(Case when date(`DateTime`) = CURRENT_DATE() then `Value` else 0 END) and the Previous value needs to be aggregated:…

@IVG Maybe try removing the today filter on the card and see if that works? With the ordering of the data, that might fix it not showing the previous values.

Hi @IVG Referencing the documentation in the knowledge base: http://knowledge.domo.com?cid=comparativegauge, I think this could be possible: I think what I would do is a couple date beast modes to align the data so for both yesterday and today we're looking at the same date: Date filter to filter on dates less than now:…

hi @Nikse, Just looking at the info in the knowledge base here: http://knowledge.domo.com?cid=filledgauge I think if you create a schema that has the date value as the category (not shown on the gauge) then the day of the year number as the Gauge value, with 1 and 365 (or whatever your season day of year values are) as the…

hey @vcsmedia, This should be possible in ETL. The knowledge base has a good article outlining setting up the "Uncollapse Columns" transform: https://knowledge.domo.com?cid=etlactionseditcolumns Let me know if you have additional questions.

hi @user05933, I don't believe there is a way natively to disable the branding. I would talk to your Domo account executive if you need further insight. Best of luck!

Hey @smriti, This sounds like a bug. I would hit up http://support.domo.com to report the bug and get some eyes on it. Best of luck!

Hey Leon, To get revenue for the last 12 weeks, you could create a beast mode that utilizes the date_add() function. example: SUM(Case when `Date` >= DATE_ADD(`Date`, Interval -12 Week) and `Date` <= NOW() then `Sales` else 0 END) EDIT: Just saw your example that you included. Based on the example when the revenue from…

Hey @user009854 have you had success pulling this report in the past? This would probably be better directed at Domo support http://support.domo.com

Hi @user07312! What report are you pulling, and what is the timeframe you're looking to pull down from Facebook? Also, did you specify a backfill period when you deployed the dataset? Depending on the amount of data in the report and the timeframe you're looking to pull down (Longer timeframe means slower run time), you…

@RXA this is awesome! Have you had any success using the built in Sumo cards in Domo? They function like a pivot table. The reason I ask is because you might want to work with the Domo product team to fill in any gaps in Sumo that your app fills, so that the product itself is continuing to grow in functionality, rather…

Hey @user00426, some of these metrics are available through the Twitter Ads connector for paid metrics. Twitter locks many of its organic tweet metrics behind a paywall through a company they acquired (Gnip), so chances are unless Twitter changes its offering, those metrics will be hard to come by unless you're willing to…

@DMJerry I found this in the Instagram quickstart for hitting an image stored at a publicly accessible URL. If you're able to get the credentials stored and concatenated to your image ftp URL, I don't see a reason why this wouldn't work: In your Beast Mode calculated field: CONCAT('<img…

Hi @DMJerry, I have to preface this response with the disclaimer that I don't know if this solution will work, but I found this https://www.cs.rutgers.edu/~watrous/user-pass-url.html that references storing ftp credentials in a URL. So you may be able to put the username and password in the url with your nested HTML to…

Hi @mark_snodgrass, One thing you can do is create a custom report that includes the fields you need to see from GA. This would include page names and visitor metrics along with any other dimensions you might want to include to slice the data. This would give you visitors by page. The knowledge base is a great resource for…

Those three solutions make sense. I've done the first two, and while they do require some management, they work fairly well as a minimal touch solution. Another solution that goes along with #2 below would be to use Box to drop the files into, then use Domo's Box connector to bring the files in and run the merge dataflows.…

hi @user00426, The basic Twitter connector is pretty limited in what can be extracted from the API. This is because Twitter locks many of the tweet level metrics (unpaid) behind a wall that you have to jump through hoops and pay to get behind. You won't find many if any organic tweet metrics through the Twitter connector…

Hey @bdetcher! I don't know if there's a way to do this by changing the y-axis directly. One workaround that came to mind here would be to create a stacked or grouped bar with both sales and margins as grouped y-axis values. Then the user could just filter down to only see the sales or margins. Same basic functionality,…

Hi @Marc_H! If you're the owner of the dataset powering the card, probably the easiest way to do this would be to click through from the card to the dataset itself, then export from there. Otherwise you'd have to remove the row limit on the card to get the full set from the card directly. Hope this is helpful!

Hey @jbandley, this should be a quick setup with the Alert button on the card you're looking at. If you're looking at a single value for a percentage, you can select the "Maximum of" metric so it pulls a non-aggregated percentage value. Then you can change the "Meets this Condition" field to "Decreases by -" and specify…

hi @odedbadt I'm having a hard time reproducing the issue, the column lables stay the same for me as I reorder the table card columns. Is this during the Analyzer edit that this is happening, or is this after saving the card and re-editing it?

Hi @user04669! That is likely what's happening here, is that it's sorting cases in addition to alphabeticals. What you can do as a possible fix for this is to create a simple beast mode that looks like this: LOWER(`Your Column Here`) Then go ahead and sort by the newly created beast mode and see if that fixes the sort…

@swagner bummer! I thought that would work for sure. The only other solution I can think of would be to recreate your fusion logic in a quick dataflow and switch the cards to the new output. Not ideal I know. Hope you can get it figured out.

Hi! Sorry to see this never got any replies. I'll give you a bit of insight from my perspective working with stacker. Stacker works well when you have datasets from different sources that contain like metrics. A common use case for this would be social media data, where YouTube, Facebook, Instagram, etc. all contain…

hey @cwolman! For larger datasets at least, having multiple transforms is a good way to go, in my experience subqueries seem to bog down a bit for the larger sizes. For smaller datasets, do it either way, whatever works best for you. Seems like you're on the right track!

Hey @swagner, if I remember correctly, you can put PDP on the datasets that are powering the datafusion and it should work correctly. (Same with dataflows and outputs). Hope this is helpful!

Thanks @Valiant I'm going to give it a shot and let you know if it works!