Jaketh13

domo

💎

About

Username
Jaketh13
Joined
Visits
6
Last Active
Roles
Member, Domosapien
Points
115
Badges
7

Comments

  • @simontarry76 It would definitely be more complicated, but you might still be able to pull it off with Rank and Window. Depending on how your data looks, it may be more worthwhile to find another way to get the needed information to your users. Is there a particular business question that you want users to be able to…
  • @Ashleigh in that case, your issue may not have been resolved with Google's fixes. If you get any new errors after last night, I would check with Google to see why I'm hitting a rate limit intermittently and create a support ticket so that Domo can track users being affected by this as well.
  • @simontarry76 That is correct. The "Total Row" and "Subtotal Rows" calculate based on the full DataSet, as the row limit is not a filter, it's just a visual change. If you want to be able to look at the totals for just the top ten, ignoring values that fall below that, I would suggest running the DataSet through an ETL and…
  • @Ashleigh it looks like Domo is aware of an issue that looks like this from yesterday: https://status.domo.com/ It was identified as a Google issue which Google was tracking here: https://issuetracker.google.com/issues/144720108 If you are still having issues today, it may be a good idea to open a ticket with support so…
  • @simontarry76 If you are specifically wanting to send these reports to users outside of Domo, another option would be to add them as social users. You could then make groups like @Ashleigh suggests. For the rest, I think these suggestions are great ideas for improvements to further customize scheduled reports. We currently…
  • @user18108 This is likely a permissions issue on the machine where workbench is running. Try running it as an admin to confirm. If you are able to run it successfully as an admin, you probably need to be added the the Domo Workbench users group on the machine. There's some instructions on how to set up this group…
  • Exactly, there's some documentation around it here: https://knowledge.domo.com/Visualize/Managing_Cards_and_Pages/011Managing_Pages#Moving_Pages_in_the_hierarchy
  • Hey @clloyd01 The easiest way is to use Period-over-Period Charts. You can then use filters to get the teams or individuals you want to look at and can use the date range to select whether it's DoD, WoW, MoM, QoQ, or YoY. If your data is too wonky to work properly with these card types, you can either clean it up or use a…
  • @tleong you should be able to change it in the "Details" tab in the Settings or when you create a new one you'll have a drop down with "People" as an option.
  • Hey @tleong, Actually, I was poking around at it and you could use the "People" DataSet from Domostats. It has a "Last Logged In" Date that is NULL if they have never logged in. That would be the simplest way to identify users who have never logged in.
  • Hey @jstan, As it stands currently, you would need to set up an alert for each PDP policy. If you didn't want all the users in the group to see the same alert, you may even need to just add the individual users to their own PDP policy. In the store manager example, there isn't really a way around this. However, there are a…
  • Hey @sdarmody Unfoturnately, it looks like this data is being entered manually in SFDC and therefore there is some variation in how different users are entering the states. The only thing for it would be to clean up the data now that it's in Domo (or possibly have them all to go back and fix it, but I don't know if that's…
  • @tleong Depending on how long you've had Domo, you could use the Activity log for this. The activity log will only go back 120 days, so if you have users who logged in before then, it wouldn't confirm that for you. moving forward, if you exported the Activity Log from the Admin Settings for the last 120 days and pulled it…
  • @user08235, Unfortunately, not yet. The only suggestion I would have is to make it a drastically different color than the other lines using color rules. That said, it sound like a great idea. For things like this, you can check out our Ideas exchange here https://dojo.domo.com/t5/Ideas-Exchange/idb-p/Ideas. If your idea…
  • @user08235 Definitely. If you already have them broken out by columns, and your aggregating the other two, then you should be able to create a beast mode that calculates the variance and put it in as another series. So, you'd want to leave the `Sales` and `Budget` columns in the Y-axis and the first series. Make sure…
  • Hey @user08235, @nicolasfeddern's answer is definitely the easiest. If for some reason that doesn't work for your data, you could also create a DataFlow. Once it's in the card, you can graph your column and break it out by series, but all the values need to be in that column. You can create a DataFlow where you pivot…
  • Hey @Lara, It's not currently possible to set color rules of off the two columns you're comparing. The column the conditional formatting is applied to needs to be a static value in the visualisation as well. You could create a column that gives the difference or even just flags the rows where column A > column B and set a…
  • @user08521 There's no other way to set up scheduled exports of that data from Domo. I should also let you know that I've been informed that there are changes being made to DomoMetrics and they are temporarily unavailable to be requested. That said, you could call whatever data you need through the API still, you will just…
  • @kbota While it's possible to set up a Workbench job to watch a particular file, Workbench doesn't support dynamic name changes for files. If the name will be different each time, your best bet would be to write a PowerShell script that renames the file for you.
  • There are quite a few metrics available. Here's a list of the names of the DataSets generated to give you an idea:
  • @user08521 If time sensitivity is not an issue, then you could just export the Activity log manually every once in a while. It will give you a CSV or excel file with the information you need. If you want it to run regularly to keep the info up to date, you can set up the DomoMetrics DataSets on your instance (by going to…