NewsomSolutions Domo Employee

The problem I think is that you can have a card exist in multiple places...so you'd count all those. Then if you just have it minimized on a page with others, which some people may count as a view b/c some cards are just needed to get some KPI picture very quickly, those would need to be counted. In theory, they should…

https://knowledge.domo.com/Release_Notes

Thanks @Valiant I'll give that a shot.

On each row you should only see the sum of that Sales Rep's quota. In a table there is no way to show the sum of all quotas on every row unless your ETL and underlying data is problematic. If you have data, similar to below, you'd need to change Date to just Month() or MonthName() from beast mode...then do your sum(Quota)…

If they aren't in there, I'd edit the card and remove the field you are quick filtering and re-add it and re-enable QF. Sometimes that has worked for me.

Check the attached pic I just added to this. They moved the quick filter off the page a bit and you may be showing them, but just can't find them.

Have you checked your datatypes to make sure the underlying datatypes you are using hasn't changed?

To fix it, you have to disable SSO, close your browser, open it back up...change the email address for the user (which you can't with SSO enabled)...then turn SSO back on (where you may have to re-configure it). Just FYI in case you need that info.

Just out of curiousity, why the request for the exact file vs just contains or starts with? Too many similar files? Performance?

The excel mindset is tough to break. For a lot of what I see is that people are used to looking at data with a floodlight and just hoping they spot the important KPI....where as Domo is more like a spot light and focuses on only the important KPI. Plus with Excel you have a lot less control of what is being used, if the…

My fault. Yes, you are right. Could you just show the total in the macro, then just reference the legend for the series name? Does the full value of those acronyms there not fit?

here is a link that may help https://knowledge.domo.com/Connect/Personalized_Data_Permissions_(PDP)/PDP_vs._Publication_Groups Sounds like you want Pub Groups if you want to control what they see. But if they need to communicate with another dept...then that would cancel that and you'd go PDP. In the past I've created…

And the job has no errors and ran fine? Did you look over the logs?

I don't think so, they are pretty limited. What you could do is use the "Show Total Label" in the Data Label Settings...to show the value w/o using the macro...then just use the Series Name as the only macro. You'd get both values with just one macro. - matt

You don't have Preview at the top showing because you aren't focused on a job...so if you expand the jobs and highlight one you'd get that option showing back at the top...if not close and reopen workbench. I'd try to close/reopen workbench if that doesn't work. If all else fails, think about what version of workbench…

I'm not sure if you've gotten this resolved already but for SFTP you may want to use workbench if you don't have a password and it is just using a key. I've done that and it works. -matt

You should have a small tab at the bottom left of your screen that has "Preview" and another that says "Output". If you hit the X in the preview pane and it shows up and is just blank, hit the "Preview" eye at the top on the menu bar and that should work.

I think the only way you'd be able to do that is having the "multiple users" also co-owners of the datasets that make up your ETL or if the "multiple users" were set with the Admin role. - matt

@Casey_F you may have already figured this out, but just in case you didn't there are two types of heat map cards. One is in "Other Charts" and does not have the totals. The other is under "Table" and the "heatmap table" DOES include the totals. I'm not sure if that would help you or not, but wanted to pass along. Thanks…

@AS that is not in production so I don't have access to that...I'm not beta. I don't have a Roles page for Default Admin...support let me know. Thank you!

Thanks @LLucinski I saw that too. I wish we could drill down into them..that would be great. They change based on the card type and data you have it in on how they write it up...so that is helpful for people new to the cards/data.

@WizardOz are you checking my syntax? I've made some edits below to describe what the query is doing so you can edit where needed for you. (case when `date`> CURDATE()-7 and [This it the field you are searching] IN ('string1','string 2', 'string 3', 'Comments', 'Shares', 'Subscribers') then sum(`Total`) when`date`>…

Yea, your best bet may be to just name the label '.' and the card with the original name. Easier to search that way if you need to find it. I wish Domo had a way to suppress card names as an option, but they don't. I'll put in as an idea b/c I think they should.

Try this... (case when `date`> CURDATE()-7 and `Category` IN ('Views','Likes', 'Dislikes', 'Comments', 'Shares', 'Subscribers') then sum(`Total`) when`date`> CURDATE()-7 and `Category` IN ('Avg Watch Time (Sec)', 'Avg Watch Percentage (%)') then avg(`Total`) end)

Do you have a default email client selected for your system? It may be local to your system? Does clicking that same mailto in a dummy HTML file that you open in a browser open a mail client? Matt

Rename it to just "."

Olivia - what about your result is not what you want? Error? Data being aggregated incorrectly? Incorrect dates being included? Do you have the real Case statement you could include? - matt

If you have access to the ETL, you could build in a new field for minutes. So if breaking up the promo field taking everything before the : and then multipling by 60, then take everything after : and add that straight up. So for this you'd have 150 seconds (I hope my math was right there...late night). If you don't have…

It's late and I may not have read through everything correctly but follow me here. If you don't have access to ETL and your beast modes are only doing one peice to a two piece calculation. Why don't you just leave two BM...one for a flag for 'pizza' and one a flag for 'hot dog'...then do a filter on your card for those…

Is there any other critiera in the data that is consistent? What I mean is that are there fields like "1.0 blah" or it is only "1.0", "9.9999", or "N/A" type examples? If the only other non-number you have to remove is "N/A" could you use "Replace Text". If there are others like "1.0 blah" and there is always a space…