Best Of
Re: Reddit connector solution
Hi @Ainash
The two main options are writing your own custom connector within the Domo platform or utilizing a scripting language like Python and the pydomo SDK / package to import data into your domo instance after programatically pulling the data from the reddit ads API.
Custom Connector: https://developer.domo.com/docs/custom-connectors/connector-dev-studio
PyDomo SDK: https://github.com/domoinc/domo-python-sdk
Re: Getting Current User Profile Data
Hi @MosesWynn
You can utilize a Dynamic PDP policy for a trusted attribute. I've done it in the past using an employee ID to dynamically apply PDP when they're looking at specific pages.
Re: Domo Everywhere and Access Control
Have you tried using private embed instead of a public embed? Private requires users to be logged into Domo to view the report.
When you choose the Private option, users will need to authenticate to see the embedded content. Because the private embed option uses authentication, filters can be personalized via PDP or programmatic filters.
Re: Running Total Group Bar - keep running total but in a specific range of time
Thank you so much for your response, Mark. It was really helpful. And I'm so sorry for my late reply.
Re: Drill Path from same Dataset returns zero value
I think I understand what's going on now. The activity log doesn't tell you which card is part of which page.
Are you wanting to count a page view as a card view? Card Views are only counted when a user views the detail view of a card and not when it's displayed on a page.
If you're wanting to count just the card detail views in your drill path you'd need to combine the activity log and the cards + pages dataset together based on the card ID and the object ID and making sure to filter for only CARD types. Then you'd need to rename the Page Name field to the same name as the Activity log field for the page (Object_Name). This would then allow you to filter in the drill path on the same name and pull all card view activities to calculate.
Re: Datediff per month
Hi @user046467
You'll want to use PERIOD_DIFF instead of DATEDIFF:
PERIOD_DIFF
Returns the number of months between months in two date columns. For this to work, the date values must be months in the format YYYYMM.
PERIOD_DIFF('Month 1', 'Month 2')
Re: Drill Down From Summary To Detail Records
You can use them on Domo pages and dashboards. It'd take you to a separate card and not drill directly in place / filter your dataset on that dashboard.
Re: Drill Down From Summary To Detail Records
Using Pfilters to Apply Filters from URL Query Parameters to Embedded Dashboards
This knowledge base article outlines the process and the format of the pfilter get parameter in your URL.
Re: Pacing Card?
@MarkSnodgrass that is awesome! thank you. I built it out and it's basically says the same story. It's not what I had built in the past, but it will definitely work. Great explanation. That was easy to follow.
Re: Pacing Card?
One way that I handle this is to use the period over period card and set the date range to This Month and graph by Month and compare to 1 Month Ago. Then, to keep the previous month to only showing its total to the same amount as where the current month is at (i.e. compare through the 17th for each month) I create a beast mode like this:
(CASE WHEN DAYOFMONTH(`date`) <= DAYOFMONTH(CURRENT_DATE()) THEN 'Include' ELSE 'Exclude' END)
I then put this beast mode in the filter and filter to include. This should show you how your are pacing in the month.
