MichelleH Coach

@user084060 I've also used Redshift quite a bit for the same reasons as your team and also found it frustrating to have all column names in lowercase, especially when using interactions on dashboards. More recently, however, I've started using MagicETL v2 for the majority of my new dataflows instead of Redshift. The…

@maodag Have you tried the PostgreSQL connector (non-federated)? It looks like you can write a query directly in this version of the connector: https://domo-support.domo.com/s/article/360043436273?language=en_US

@MarkSnodgrass @NathanDorsch I am an admin in my instance. I can click the 3 dots on datasets/dataflows but not on dataset fields.

@MarkSnodgrass I am seeing the same in my instance as @NathanDorsch

@NathanDorsch I ran into the same thing when I tested. This is probably an issue for Domo Support.

@NathanDorsch What happens when you click the existing tag?

@NathanDorsch Can you send a screenshot of what you see when you click on the tag?

@NathanDorsch Yes, if you want to know the number of unique values in each field then you will need a distinct count.

@AndreiA Is there a pattern of when a character would be uppercase vs lowercase in your id field? If so, you could create a secondary concatenated id to use for ranking. For example, if the last character is uppercase for Product A and lowercase for Product B you could use a formula like this to create your new partition…

@NathanDorsch You could use a PivotTable card to export, but you would still have to create a count(distinct) beast mode for all 400 fields.

@NathanDorsch You can see some high-level statistics for each column in the Data tab of your dataset by toggling the statistics icon to the left of the column headers

@Stuck Case statements tend to get messy when mixing aggregates with row-level data, which is likely the cause of why that is not working. Have you tried wrapping a MAX() around your CONCAT() to artificially aggregate your one row? If that doesn't work then it sounds like you've found a decent work-around by splitting the…

@Stuck Does your underlying data contain multiple rows for each Project Manager/Project Name? If all your projects are returning 'Please Filter on Project', then there is likely an issue with your COUNT() = 1 criteria.

@maodag What connector are you using to create your Federated Datasets? Some connectors allow you to write SQL queries directly in the request. You could also use MySQL dataflows, though that requires having a dataset created for each input table. Here is a KB article that outlines all of the available data processing…

@Abhishek_Singh You should be able to do that by setting a MAX aggregation on your completeddate column.

@snguyen I don't believe there is an option for that, but that would be a great post for the Ideas Exchange

@snguyen Do you have an example of what you mean by people icon? If you want to add a person's picture as the label for the respective bars, I don't believe that's an option for bar graphs. There is a way to add images to an HTML table card if that accomplishes what you're looking for:…

@cuidarme Yes, you can use a CASE statement. Here is a helpful article on how to use these formulas: https://domo-support.domo.com/s/article/360042925434?language=en_US

@Gabby How are you breaking the Product Name/Year into different columns? Are you using a pivot table card with the Product Name/Year field in the columns or are you using a Mega table with beast modes for each Product/Year? If you are using beast modes please share your formulas.

@Gabby Be sure that your columns for Product Year 2022 and Product Year 2022 are both set up for an Aggregation of "Sum". That should fix your duplication issue.

@bkdadomo Agreed, there is probably something in your file that is causing the regions not to be recognized. Are you able to access the file from elsewhere?

@bkdadomo Do you still encounter this issue after creating the chart type and building a card from it?

@Jean_McDonald A couple observations about your formula: The SUMPRODUCT formula in your Excel example multiplies call and email productivity by their respective weights and adds them together. Your formula in Domo simply adds all 4 percentages together, which results in the weighted averages above 100% Assuming the weights…

@cthtcc If you want do set up a card of a different chart type you could use the fixed decimal field as the value, and then use the formatted column as the data label using tooltips

@louiswatson Here is the general logic for a beast mode filter you described using one date field: case when year(`Date`) = year(CURRENT_DATE()) and month(`Date`) = month(CURRENT_DATE()) and `Date` >= CURRENT_DATE() then 'Include' else 'Exclude' end We would need to understand the definitions of your two date fields to…

@Cardoso13 I suggest you check out this article on some of Domo's Period-over-Period chart types: https://domo-support.domo.com/s/article/360042924834?language=en_US If it has to be in table format, then this write-up by @GrantSmith also has some helpful tips for making your own PoP comparisons:…

@Cardoso13 Can you please elaborate on what specifically you need from the community? Are you just trying to figure out whether it's possible to create this dashboard or need guidance on how to create this dashboard?

@gbrown Another option is to use the following formula in Magic ETL: STR_TO_DATE(`Date_Temp`,'%m%d%y')

@Pau It looks like you need to configure your output dataset (i.e. name it). Domo considers the dataflow to be incomplete if the output tile is not configured.

@AAofOO I don't believe that's an option in the bar chart, but I know it is possible in a Pie/Donut chart type.