MichelleH Coach

@AAofOO Are you looking for the total number "Yes" and "No" responses or the number per month? For totals, I recommend using a customer summary number (https://domo-support.domo.com/s/article/360043429993?language=en_US) For the number per month, you can display the value using the Data Label Settings.

@Chris220 You should be able to plot both lines using a Multi-line chart with one metric in the Y-Axis and the other in the Series. While Analyzer only allows one field in the Y-axis location, you can add multiple fields in the Series location.

@bkdadomo Yes, depending on the format of the dates you can either use the Alter Columns tile to change the datatype of the field or use the STR_TO_DATE function in a formula tile.

@willrnt Try adding a constant value in the before your Group By tile and use that as your only group by column. Since the entire field is a constant, then it will return a single value as the first non-null value in your dataset.

@a10hall Domo has an add-on called Campaigns that can do much of what you're describing: https://domo-support.domo.com/s/article/360042933494?language=en_US

@damen If an integer has less than 7 digits, then you could filter to numbers less than 1,000,000 rather than by length (assuming the data type is numerical). So for example: when `loan number` like '5%' and `loan number` < 1000000

@willrnt To find the first non-null value, you will need to use a Group By tile instead of the formula tile since you want to look across multiple rows. You should be able to select first non-null value in the aggregation type drop down. Coalesce looks across multiple columns within the same row.

@Jones01 That's correct. Locking the dashboard only restricts access to the features in "Edit Dashboard". Cards must be locked individually.

@mbelmont If it's not recognizing the file at all, Workbench may require impersonation to access the file from your network drive. You can set up impersonation in the job's Configure tab under "Impersonation", where you can enter your network domain and credentials.

@mbelmont Does Workbench give you the error when you run a preview or just when manually running?

@DavidChurchman I believe the bubble sizes in the legend are not intended to fit the charted bubbles to scale, but only the relative size. For lat/long charts, I like to use Hover Text to indicate the actual value.

@jennakmeier Cards refresh based on the scheduled settings of the underlying dataset. Can you schedule the datasets to run less frequently or during times when they are less likely to be reviewing it?

@arzconci Yes, what you posted should work if you move the first open parenthesis to after the word "when".

@damen Can you please share what you've tried so far with the fixed function?

Hi @arzconci if you click the paragraph icon on the left side of the text editor, it opens more text format options:

@arzconci Without seeing your actual data and results, the first thing that stands out to me is the OR in your criteria for 'MISS'. When you are using OR operators, be sure to use parenthesis to group relevant criteria. For example, if both of the statements before and after the OR must be true, then it should look like…

@PRC Both of the issues you pointed out seem to be related to the beast modes you are using in the rows and columns of your pivot table, specifically "Completion" and "year_val". I suggest reviewing the formulas for both of these fields and validating that they are producing the correct output.

@user00344 I'm not sure if this is what you're referring to, but there is already a CURRENT_DATE function in beast mode

Hi @SEC I believe the number of variance lines is determined by how many years are selected in the "Compare To" section of the date picker. If the extra variance line does not remain de-selected when you save it, then I recommend switching to a Grouped Bar + Line graph and managing everything via beast mode. @GrantSmith…

@SEC Could you please provide some more details on how your card is currently configured (chart type, fields used, chart properties, etc.) and where specifically you are trying to unselect the variance?

@ttronson If your PNG file seems blurry, that has more to do with the resolution than the file type. Do you have a higher resolution version of the PNG?

@bkdadomo If you can find an SVG file with the tracts (you can likely find this with a quick Google search) you can set it up as a Custom Chart in your instance: https://domohelp.domo.com/hc/en-us/articles/360042924454-Custom-Charts

@bkdadomo The card search function can often be slow. I recommend starting from the card you want to add, clicking the card options wrench, and choosing the "Move / Copy" function. From there, you can search for the dashboards where you want the card to reside. Once you click "Save" the card will appear in the Appendix of…

@bkdadomo There are multiple ways to add a card to a dashboard, so could you please share the specific steps you took with some screenshots?

@apritchett & @Billobi Note that the Domo Governance datasets only allow once/day scheduling, so if you are running the Governance dataset overnight for example it would not capture any rows that have been added throughout the day

@AttuAk Check out the Domo Governance connector. There are several different reports you can use to access this information.

@lb1234 In that case, I recommend using an ETL to aggregate the data by team first so that you have a columns in your dataset for team, count of create date (numerator), and team goal (denominator). Then you can set up a beast mode in your card to calculate the percent of goal, like below: sum(`Count of Create Date`) /…

@lb1234 Can you please explain the business logic behind the case statement in your denominator? I suspect you'll have to restructure the data in an ETL to make the subtotal work since your current calculation is only aggregated on the numerator.

Hi @gbrown try using COUNT(DISTINCT(`employee name`)) in a beast mode to count the number of unique employees.

Hi @Airbear can you please share the structure of your raw data?