guitarhero23 Contributor

You now have the ability to enable some Domo stats in your org. Check out the "Domo Governance Data" and "Domo Domostats" connectors.

Now, it would be hard to show the count of all interviews and also show only those that had offers on a single bar chart so if you're not already use something like a grouped bar using the above formula

A couple things: * Remove the single quotes from around the 1. You want it to be the number one, to use for sums, not the string 1 * You don't need to use both Offer Made is not null and Offer Made = Yes, if Offer Made = Yes that would imply it is not null. I'm not sure if it'll give you what you're looking for but this is…

After reviewing the Tableau documentation are you sure it's "writing" data to SharePoint? It would appear that it's more like the data is already in SharePoint and the specialized URL you go to is filtering the existing data to just the one you clicked on. Edit: After re-reading your message you never said "write" you said…

Hi @user10383 just FYI the Dojo contains both regular users like yourself and sometimes Domo employees will engage as well but just want to say if you need some sort of immediate help including a call it likely won't happen in this medium, I'd recommend reaching out to the Domo support team and/or your account manager. I'm…

So similar to your other question, Excel will take raw CSV and display it to you certain ways. So in Excel when you open a CSV it might show the % symbol when the underlying raw CSV data is actually .300. When you upload the raw data to Domo it correctly shows that the value is .300. On your card you can choose how you…

I'm trying to figure out of this is a Domo thing or an Excel thing. Maybe provide some example data. If I open Excel and type in a long decimal place the cell shows the shortened 1.293849204 and the formula bar shows the full number I typed in 1.2938492044567. Once I save the file as a CSV and reopen it in Excel both the…

I tried to experiment as it seemed interesting but couldn't quite get it there but you most likely would have to do this in a dataflow like a MySQL dataflow. I was looking at things like this for reference. https://stackoverflow.com/questions/39906435/convert-json-array-in-mysql-to-rows

You can do this when using the addon for PowerPoint. I know it's not exactly what you're looking for but I don't know that it's possible in the quick export or not. The below shows how the description was pulled into PowerPoint with the card. For more information check HERE

What exactly has read access? Your user account? Did you already setup User Impersonation using your credentials? When I checked the documentation your error could indeed be because impersonation isn't setup, see here https://knowledge.domo.com/Connect/Connecting_to_Data_Using_Workbench_5/Common_Workbench_Errors

Probably going to have to dive into a MySQL dataflow. Here are some potential resources: * https://stackoverflow.com/questions/26725119/fill-empty-row-with-value-of-previous-row-mysql * https://stackoverflow.com/questions/31276169/how-can-i-fill-empty-cells-with-values-from-previous-rows

You seem to have been on the right track, I didn't really need to do anything different than you did. Here are my results based on your sample data Total Active Accounts: SUM( (CASE WHEN `PS Variable Stub` = 'TOTALADaccounts' OR `PS Variable Stub` = 'totalO365accounts' THEN `UPN: User Count` ELSE 0 END) ) No MFA: SUM(…

Can you provide any sample data that I can test with? And the numbers you expect to see?

What is PXP? Is that the kind of database it is? It's possible neither GETDATE() nor YEAR() is a valid function. If PXP is not the type of database it is then please let me know what it is. Use the date functions applicable to your database. Is this PXP ODBC driver the only one you can use to connect to your DB? I assume…

Hi can you answer this first. Are you connecting to SQL Server? MySQL? Oracle? PostgreSQL? Other? Depending on the type of SQL you're using maybe the way I wrote it won't work the way I've been writing it is for SQL Server but I'm sure others use same "GETDATE()" methods, but you'd have to check. I've blanked out some info…

I followed the process I wrote about before, I wrote the query in my SQL Server database, once I got it working I pasted it into Workbench under the "Processing" section in data (where you put your query) and ran it from Workbench so that it came into Domo with only the current year, not dataflows.

I just did this in my Workbench connecting to SQL Server, using the same WHERE clause as I put in my answer against my own DB and it successfully transmitted to Domo

What's not working? You were able to run it in the DB successfully but not in WB? What SQL are you using?

In the chart settings to to General>Maximum slices before 'Other'. Add a number there that is higher than what you have. Note though that there is a limit to how many names will show up in the legend before it just says "X more..."

Aw man what am I supposed to do now if I can't answer your question?! (Oh right, I have other work to get back to). There goes the Dojo magic. Glad you figured it out, don't forget to mark your answer as a solution to close it out ?

To your point in #1, are you saying you don't want a state map or a county map that is populated using your zipcode but you want a US map that is displayed by zip code? If my interpretation is correct Domo doesn't natively have an area code map for the US but you could populate the density of counties based on the zip…

Can you give us some example data to show how it's structured? The solution can be different depending on the schema

@DaniBoy is this something you can help with or know who can?

You have the right idea, what about that didn't work? What flavor of SQL is this being pulled from? If you have access to the database build your query in there and check your work, if it runs in the DB then just copy and paste that into Workbench. If it didn't work in your DB then you'll want to figure out the right way…

(SUM(case when `Period`>='2019-01-01' and `Period`<'2020-01-01' and `Ledger Type`='AA' and `Suppress Plan Month`='No' then `Amount` else 0 end)/MONTH(CURRENT_DATE()))*12 Try doing this MONTH(CURRENT_DATE()) Edit: Oh wait when you say previous month are you saying that this month being August (8) you want the report to be…

I would recommend using the API to do this, it will require the following. 1: Script that pulls down the data of a specific dataset into a CSV (all doable with the API/SDK. I've done this in Python). 2: Once the file is downloaded the script would send it via email 3: A way to run the script on a schedule so that you can…

I realized I hadn't done it since Workbench 4 so had to go look. On the overview tab click the down arrow on the right of "Domo Details", it'll expand and show a browse button next to "DataSet Name" allowing you to choose a Domo dataset.

That doesn't sound like it should be expected behavior as exporting/importing I'd expect to be the same. Try importing it again and this time go to the settings where you can select a Domo dataset and try seeing if the one you expect is listed, even if it is try clearing it out and researching and choosing the desired…