Best Of
Re: I have an unexpected outcome of a beast mode calculated column, can you help?
Hi @Stuck ,
Any way you can show the actual data or a mock up? It'd be good to see a screenshot of what these fields look like and your formula to the right in a table to gain more context.
Re: How to group data?
There are a lot of ways to group data in Domo. In your case, I would suggest using the pivot table card to have the months as columns. Here's the KB article that would help you learn how to set it up.
https://domo-support.domo.com/s/article/360043429473?language=en_US
Hope this helps
Re: Breaking down bundles into individual items
Hi @Mattwjones ,
So shopify is a bit of a beast. If you need revenue, I would suggest just pulling from the Orders report. However, if you need to know progress of individual products, you'll have to use the Order Lines object. It's quite a doozy becaus the order lines report, double counts revenue becase there are usually several types of taxes and it gives a how new duplicate row because there could be a breakout of tax by state, county, etc .
Feel free to email me at john.le@dashboarddudes.com and we can discuss more,
John Le
Re: Issue in creating pivot table
Hi @PRC
Here's a quick video to help. Truthfully, I don't think I have enough context, but hope you can see some tips from this video: https://www.loom.com/share/779575aed8854ce689c3ec0981175e47
John Le
Re: Need help with beast modes to show yesterday's invoice total amount, and previous year, current date
Hi @anh_tr_huynh4 . Here's a video explanation of what you need to do: https://www.loom.com/share/70b71aee2ec44253bb4638c9862f50cb
Anyway, you're on the right track, but I don't think your formulas are doing what you want them to do. By using the year and month functions, you're really saying to get a sum of invoice amounts for an entire month and not just yesterday.
Hope the video helps
John Le
Dashboarddudes.com
Re: Trouble with uploading KML file into a Custom Chart
@bkdadomo Agreed, there is probably something in your file that is causing the regions not to be recognized. Are you able to access the file from elsewhere?
Re: Snapshot Fields Accuracy
Hi @renee12345 ,
What's the datasource you're pulling data from? I ask because if there's something like a Last Run Date or something like that, you can leverage that.
Re: Export Dash as PDF from button in UI
Hi @wilbaile ,
One option you have is to put their emails so schedule a report to your clients each day, week etc. It will just be a picture more than a PDF, but you can attach the underlying excel file as a table if you need.
Your BEST option though seems to be to just allow exporting on your embed options. Here's a video I made of your possible solutions: https://www.loom.com/share/2038362b634a42389dfcb59b7aef8b33
Good luck,
John Le
More videos at https://www.dashboarddudes.com/pantry
Re: Google analytics filter capabilities
Hi @Jim_C ,
So you can pull in Source Medium from the GA connector as @GrantSmith mentions. Then if you use Advanced Filters, you can select any filter you want. Domo actually has a filter builder which is WAY COOLER than it used to be. I used to have to write in some gnarly JSON code, but now Domo will do that for you. Here's a video: https://www.loom.com/share/196acf511002496caa4dc3e5dfab862a
This was that old JSON code I mentioned:
{
"dimensionFilterClauses": [
{
"filters": [
{
"dimensionName": "ga:sourceMedium",
"operator": "EXACT",
"expressions": [
"Thing you want to filter"
]
}
]
}
]
}
But honestly don't even both with this if you can use their filter builder instead.
Good luck to you,
John Le
More video solutins at: https://www.dashboarddudes.com/pantry