guitarhero23 Contributor

Are their differences between your "Actual" data and the "Goal" data? The Actual is adding up correctly

Normally it does...I just tested on mine and it correctly changed the total row based on what i had filtered. How are you getting the column data? Is it some sort of beastmode or other manipulated data? I'm wondering if that is causing this.

Is that the column you're using on the Y access? If so you could probably just use the standard Color option in the chart builder. Below I have a beast mode that is COUNT(`Id`) and is what powers the Y axis. In the colors builder I just have it set that when the column COUNT(`Id`) is greater than 100 make it red, if it's…

What type of join are you doing? How are you performing it, ETL, SQL dataflow, fusion? I ask because you should be able to join with both datasets having them, they are standard in Domo and I've yet to run into it. MySQL dataflow join example below Table 1: "Favorites" * ID * Favorite_Color * Favorite_Food * UserID *…

I've run into that issue before depending on the type of machine. If you don't have admin and the admin installs it using his credentials Workbench will then reference their user profile (on the computer) when you browse for files and such. You should still be able to get to your folders I believe but would have to go…

I do not believe this capability exists in Domo, it would show in the date section when interacting with the card and you could make a calculated field to make sure it shows somewhere in the data, but not the title.

I don't have a direct answer to your question but I've found it best to pull in the entire object (columns I choose) into Domo and then recreate what I've done in a report if I have a specific need to, that way you can have 1 dataset that can power many cards vs a bunch of disparate datasets based on random Salesforce…

How does the data appear in Dynamo DB itself? Are you saying it seems Domo is combining it into one column or are you saying you are storing as shown, all in one, so Domo is then pulling that. I haven't attempted a Dynamo connection before but set this one up to test and it appears to work as expected.

It sounds like you're doing everything right. I just did this today for the first time and it worked fine. Just to confirm you're doing what it sounds like you're doing. 1: Go to Admin Settings>Security>Access tokens 2: Clicking "Generate access token 3: Copying the exact token where it says the warning about not being…

Not intending to revive an old post but I got here via Google so to answer the question for others who end up here it appears this has been available since the October 2018 release though I don't see it in my instance so seems you might have to contact Domo to activate.…

How many clients would you be giving access to? I haven't researched too into Domo Publish but you might be able to make use of it. https://knowledge.domo.com/The_Appstore/Available_Apps/Domo_Publish_App#Intro

When viewing a card you could see it at the bottom of the page. In a slideshow I'm not sure. The column that has that is Domo's default _BATCH_LAST_RUN_ but you can't use it as a summary number. I'm assuming you're talking about a publication when you saw slideshow so in that case I don't have a slick answer for you

What datatype is your date stored as?

 That makes sense why I was confused, I thought you might have something custom I wasn't aware of. how it worked. Thanks for the update.

Ha, I didn't notice a reply to this thread and when i came back to double check i noticed my spelling error in the title, dangit. From what I can tell so far I can only access the underlying data, I'd essentially have to rebuild the card with some excel programming or something which I'd LOVE to avoid even venturing that…

It's funny you mention that, I had the exact same problem. The tough part is that you have to choose a date column based on your data, which makes you have to use created or resolved. Trouble is, you can't use resolved because you want to show tickets that aren't resolved as well. I gave up but read through the link below.…

Can you give a brief explanation of your use case? I feel like I'm missing something with what you're trying to do and why.

Clearly it's a friday and my brain decided to skip over words, my bad. I'll see if I can do a test for workbench

I haven't attempted this before but just created an S3 bucket to test and got it working without much trouble. I created a bucket called test-bucket18 and put the file into a folder called Domo and named the file Test_Domo_S3.csv When creating it you have to use the keys you get when setting up a user (access + secret).…

These are the options I'm aware of. 1: Set it up on each card (as you know is more time consuming) What would probably be the best way: 2: Use Personalized Data Permissions (PDP) policies to make it so when an external user looks at a card they only see it where the data is external_user_field = True. You can setup one…

The one I was able to use in the previous version (and works in Workbench 5 in terms of populating the boxes, just doesn't actually save) is Provider=sqloledb;Data Source=XXXXXX;Initial Catalog=XXXXXX;User Id=XXXXXX;Password=XXXXXX Not sure how Oracle differs but this one is for Microsoft SQL Server

I don't have an answer but it seems like Workbench 5 is changing the names of things. I just created a dataset in it and now instead of my connection to SQL Server coming into Domo as "Generic OLEDB" It's OLAP via Workbench which is now different than all my other jobs. I'm finding Workbench 5 to be more appealing visually…

When you say pre built data connector are you talking about a cloud source from one of Domo's ready to use connectors? Which works now, not through Workbench? Edit: Saw you post somewhere else about it being Salesforce data. I'm not sure how you might encrypt data coming from an online source like that. It's easy if it's a…

If you had it set like this it would appear correct. Dataset 1: Id Name Date Dataset 2: Id Color Food Activity You should set the top card with dataset 1 however you like. Then when creating the drilldown switch the dataset to Dataset 2. Make sure Id is on the card you're drilling down to (I can't remember if it's required…

The notion of header and footer doesn't really exist as you might be thinking of in Domo. Some options: Card Title and Description. Add some information in the description, when you hover over it'll display. Page Collection. On the dashboard you could create a collection of cards. The collection has a title and a…

I'm not sure exactly what you're referencing when you say "Self service Domo" but the bulk of things in your document would be the same rating. Profession or Enterprise (current offerings on https://www.domo.com/pricing) are mostly to do with limits on things like data storage, security, how often you can update data, etc.…

Can you provide more information? I'm not really sure what you're asking.

Can you provide some more info about your use case? I agree with the other post, it seems like you may be better off doing things somewhere else to bring into Domo

Maybe someone else might chime in who has an idea. I'm not quite sure how using personalized data permissions works on social users. I think it'll be a little more involved than you may initially think. Social users have very limited access and I'm not sure it'll support the use case you want.…

You certainly could but it depends on HOW you plan to do that. The cost would likely be too high to have it setup so that all parents could go in themselves and if they did you'd want to make sure you have agood grasp on limiting data with PDP so that they can't see any data other than their childs. Assuming you won't be…