Best Of
Primary Key/Index Magic 2.0 Tile Failures
Hello!
It would be great if there was some sort of notification/error on Primary Key/Primary Indexes in Magic 2.0, it's a great unintentional feature on MySQL dataflows and helps greatly with data integrity.
Get MySQL on latest version
Currently, Domo's MySQL is on version 5.6, which is approaching end of support. There are also a number of commonly used features that people want to use in MySQL, but can't because it is still on version 5.6. Please upgrade to the latest version.
Custom User Profile Fields and be able to use them as Trusted Attributes for PDP
I think it would be extremely useful to have the ability to add custom user profile fields. For example I have people that cover geography that's not just based on the "location", some cover districts. Also have users who back up certain sales people. If I could add custom fields to match values against our data I could build more PDP policies to make each users experience fit their needs with less effort.
Today I am accomplishing this by setting up individual PDP policies with each user named. If I could set it up based on additional trusted attributes it would be more dynamic when a users coverage changes, or new users are added.
swagner
Alerts - When Dataset Fails X times in a row.
We are all overwhelmed with email alerts on dataset failures, right?
How often do you open the dataset only to find that it was a single random failure, and has since run successfully?
I think it would help to have a setting where the dataset/dataflow failure alerts only trigger when there have been multiple consecutive failures.
Data Center Filter Options Enhancement
When trying to use the filters option in the data center to find particular datasets or dataflows, after selecting an option such as type or tag, the popup only displays the top 10 options. I know you can start typing, but if you aren't sure of a name until you see it, it is difficult to find what you are looking for. It would be helpful it there was an option to show all or a scroll bar in there. Perhaps adopting the logic that is used elsewhere in the data center, such as when you click on a dataset and then click on the data tab and you want to filter on a column.
Current filter display:
Proposed enhancement filter functionality that allows you to see all options:
Re: How to add percentage in the pivot table?
For % by category, you would use:
over (partition by Category) in the above formula.
You'll need to check with your Customer Success Rep if that feature is enabled for you.
amehdad
Re: Foreign Currency Conversion Help
Hi @RichYute, there's a connector called Open Exchange Rates that you can use. Have a read of this [https://domohelp.domo.com/hc/en-us/articles/360043432893-Open-Exchange-Rates-Connector] before setting it up it in your ETL.
amehdad
Summary Gauge enabled for all charts
Just as how the Spark Line and Bar has a gauge to shows the degree of change in a summarised manner, it would be great to be able to enable that feature from 'Chart Properties' across the popular charts. It provides a period-on-period progress snapshot along with showing the trends across the wider period ranges in one compact view without needing to have one chart card and one comparative gauge card alongside each other in a dashboard/page, saving space and time during filtering/data refreshes.
amehdad