Jaketh13 Contributor

@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 @user09844 Domo will generally just run the query and hand back any errors that Redshift says that you have. It's not generally a "user facing" version of the error. It's just the straight up error that it ran into. Unfortunately, sometimes Redshift doesn't give much information when a query fails due to syntax. If…

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…

@user05688 This looks to me like a possible bug. I can recreate it as well. I would shoot a case over to support from support.domo.com. They should be able to help you out from there.

@user02990 You can only set one target per card, however, depending on the chart type you're wanting to use, you could set a few more by graphing them. For example, if you're doing a Bar Graph, you can use instead a Line and Bar Graph and create a column that has your target repeated for each value. Then when you graph it…

Hey @mbelmont, While there isn't a specifc date listed for when a simple UI feature like this will be available, there is a KB article that does the brunt of the heavy lifting when you're trying to get the number of business days between two dates: http://knowledge.domo.com?cid=datediff Using this, minimal SQL knowlege…

@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…

@user003279 First, I think this would be a great enhancement request. It doesn't look like it's currently possible to use a date value in both axes. That said, I have a potential, moderately tested workaround for you. What I would do is create a new column that is a copy of one of the axes then convert it to a string. you…

@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:

@AshfordLC That message generally means that the ETL is not encountering the format that it's expecting. One thing to double check is that you are setting the "What format is the date in?" to "Month first". From the example value you provided, it looks like that should be the one.

@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…

@user02741 Any luck with the file?

@Godzilla @user07065 Something I realize I didn't clarify here that may be the issue you are running into: Summary numbers can only be aggregated fields. If you try to just stick a string in a Beast Mode, it won't allow you to use it by itself.

@user02411 I should add that using DATE_FORMAT will make the column text instead of a date.