Best Of
Re: AzureAD to Domo for User data
Hi @TommyDenn ,
To add on to ArborRose's response, we used the "JSON No Code OAuth Connector" which opened up the use of Microsoft Graph under the "Data Selection" part:
You can use Graph Explorer | Try Microsoft Graph APIs - Microsoft Graph to test your request and make sure you're returning the data you want
Hope that helps!
RK_CFL
Re: AzureAD to Domo for User data
@TommyDenn
Apparently Microsoft Graph is the official API for accessing data in Microsoft 365 and Azure Active Directory. Try connecting through Microsoft Graph's API us OAuth2. You should be able to access user profiles, last sign-ons, groups, titles, departments, etc.
https://learn.microsoft.com/en-us/graph/api/resources/users?view=graph-rest-1.0
Re: I am trying to send a list of domo users to my email every quarter using Workflow.
@Anna_Otake hey there! I'm late to the party here but just to piggy back off of what Michelle mentioned. If you go to the People Report in the Domostats connector (maybe refresh once a week?), build a simple table card off the dataset, then setup a scheduled report for the sending cadence you want and select the report recipients (include your non domo user email as well). A workflow could work, but you are missing this dataset to reference and in the workflow you have to set the send trigger when the dataset updates. Keep it simple. 😉
Re: I need a beast mode that provides 2025 Sales % VS 2025 targets
@CK_16 The error can be resolved by rearranging the calculation so that the numerator and denominator of your beast mode each contain a single case statement within a sum like below.
sum(case when year(`trx_date`) = 2025 then `extended_amount` else 0 end)
/
sum(
case
when `Product Category` like 'Product 1%'
and year(`trx_date`) = year(current_date()) - 1
and dayofyear(`trx_date`) ⇐ dayofyear(current_date())
then `extended_amount`*1.055
when year(`trx_date`) = year(current_date()) - 1
and dayofyear(`trx_date`) ⇐ dayofyear(current_date())
then `extended_amount`*1.145
else 0
end)
Re: Dataset sharing not working
Hi, I actually just logged into their account to troubleshoot and I noticed they can't even view datasets or access the data center, so it must be a user role limitation. I will ask the instance owners. Thank you.
jrtomici
REGISTRATION LIVE for Domo Connections: The AI and Data Tour
Domo is going on tour near you! Attendance is FREE. Come network with the Domo community, meet Domo's product experts, and see the power of data in action.
Locations & Dates
Minneapolis, MN: Tues, Sep 9
Chicago, IL: Wed, Sep 10
Toronto, ON: Thurs, Sep 11
Salt Lake City, UT: Tues, Sep 16
Dallas, TX: Thurs, Sep 18
San Mateo, CA: Wed, Oct 15
New York City, NY: Tues, Oct 21
Charolette, NC: Wed, Oct 22
Atlanta, GA: Thurs, Oct 23
Agenda
12pm-6pm
Technical workshop: hands-on training from a Domo expert
Networking lunch (food provided)
General Session: real-world use cases from ustomers
Cocktail reception and networking
Don't miss out on this free in-person event to meet Domo peers just like you.
Register HERE.
Re: Average line
When you have a series, you can add a global-average line using the "Scale Marker" in the properties.
Re: Unable to Create Support Ticket – "New Case" Button Disabled
Based on the red message, it seems as if the support portal is having issues. I create my support tickets by e-mailing Domo support at support@domo.com . You will get an automatic reply back with a case # that you can refer to and continue to manage the ticket through e-mail.
Re: Domo Enhancement - OR Filter
Shaq is on my team. This is a UI idea for Page Filters on a Standard Dashboard. A more understandable example would be if a user needed to included data for both the country of Canada and the state of Texas. Currently they cannot easily apply filters to meet this need.
sfriebel