MichelleH Coach

@elizab Are you able to rank the elementary test scores prior to joining to the rest of the schools so that the nulls are not included when ranking?

@kaybee I have not encountered this before, but these are the first things that come to mind: Do you have any time-based filters that could be interfering with the schedules of your report or data refresh? In other words, if your card filtered to "Today" and is refreshed daily at noon, then your card would show no data…

Agreed. Tooltips should be available on every chart type.

While I could see this being useful, you may be able to achieve something similar by adding a "Category" column to the dataset in your ETL that you could use as a slicer. Granted, this depends on the number of categories you would want to search and whether these categories are mutually exclusive. case when `Prog id` like…

@Jones01 Do you know if your fiscal calendar is one of Domo's standard options or if you have a custom fiscal calendar? If it's a custom calendar, then it looks like your month abbreviations may be mis-aligned. Domo Support should be able to correct this.

Hi @WorldWarHulk are you trying to do this in a card or a dataset? If it's for a card, then I recommend starting with the calendar dataset in from the Domo Dimensions Connector (https://domohelp.domo.com/hc/en-us/articles/360042931454-Domo-Dimensions-Connector), then putting the data into a pivot table with week number on…

Hi @utkarsh no, I don't believe that's possible though others can correct me if there is a method I'm not aware of. While the logic of how you arrived at those original values is tricky, recreating that is likely your best option for creating ColumnA in Domo.

Hi @utkarsh I don't believe there is a way to accomplish this in Beast Mode since the calculation for ColumnA is dependent on previous values of the same column. Ordinarily if you needed to reference values in previous rows, I would recommend the LAG function in the Rank & Window ETL tile…

@louiswatson How are your 6 data sources related? Without seeing your data and what you are trying to measure, you will likely need to use the Append Data tile in MagicETL.

Agreed. It's also possible for a data consumer to come to an incorrect conclusion by changing the date range on a card from, say, "Month to Date" to "Last 7 Days" without knowing that the current day is one of the seven.

@jaeW_at_Onyx Thank you for posting this, you hit the nail on the head. I was initially very excited about the introduction of FIXED functions, but can honestly say I have not tried to use them because of the time involved in learning what appears to just be new syntax for window functions. As a SQL user, I find the FIXED…

Hi @charles I do not believe this is an option. Have you considered using a Pivot Table card instead?

Hi @slewis1 I would suggest using a Rank and Window tile in the ETL to add a row number column, ordered by visit date (descending) and partitioned by patient record number. You can then filter to rows where this row number equals 1 to identify the most recent visit. More on the Rank and Window tile:…

Hi @ozarkram check out this documentation on managing pages to see if this answers your question: https://domohelp.domo.com/hc/en-us/articles/360043428253-Managing-Pages

Hi @Canioagain, I don't think this is an option for the Single Value Gauge. I suggest trying a Dynamic Textbox card instead: https://domohelp.domo.com/hc/en-us/articles/360042924514-Dynamic-Textbox

@n____l____ It sounds like you will need to use a cross-join to get to your end goal of every Account/Product combination (https://www.w3resource.com/sql/joins/cross-join.php). Since cross-joins aren't a pre-configured option in the ETL Join tiles, you'll to do the following as a work-around: Create two separate Remove…

@jkami Have you looked into Filter Views (https://domohelp.domo.com/hc/en-us/articles/360042923914)? It might be simpler to preset three filter views for last 15, 30, and 60 days.

@jkami Good to know! Are you able to use a calculated field in the View instead?

Hi @jkami last I checked, there are some limitations with using beast modes as page filters. I would start by using a formula tile in MagicETL to create your Date Filter column and use that for your filter instead.

@Rahulbhandari Have you used any other datasets from the Domo Governance Connector? If this is the first one you have created, then you will need to set up an access token (see the "Prerequisites" section of the article @GrantSmith shared). Otherwise, I suggest you contact Domo Support about this issue.

Hi @Jones01 if you haven't done so already, I suggest structuring your fiscal calendar dataset like the Domo Dimensions Calendar dataset (https://domohelp.domo.com/hc/en-us/articles/360042931454-Domo-Dimensions-Connector). Then you can join to your fiscal dataset by date, to add columns for fiscal year, period, and week.…

@TracyFinn Check out the Histogram chart type and see if this gives you what you need: https://domohelp.domo.com/hc/en-us/articles/360043429193-Histogram

Hi @major_ace if you are looking for a simple division, try this beast mode: sum(`ProdSales`)/sum(`SvcsSales`)

@javiermolina Based on your table, I interpreted "Parameter" to be the name of the field, where X, Y, and Z are the values of that field. Are you saying that X, Y, and Z are field names?

@Jack_Kaye You can access this report via the DomoStats Connector: https://domohelp.domo.com/hc/en-us/articles/360043433813-DomoStats-Connector The DataSets History Report can be found under Settings > Details > Report

Hi @cbreen, a couple edits to your formula: When you have multiple conditions you need to check, you can simply contain them with a single CASE...END. Instead of repeating "CASE", you can specify each new condition with WHEN You are correct that your current formula does not account for September. You can add this as an…

@NateBI I don't believe this is an option, but I would recommend submitting this to the Ideas Exchange.

@javiermolina This is not currently an option for SPC charts. You could create a separate card for each category and set the ranges individually for each one.

@javiermolina The box plot chart only allows one series, so I recommend setting "Parameter" as your series and adding a "Category" quick filter. Alternatively, you can create multiple cards for the same dashboard and filter each one to a different category.

@javiermolina Yes, you can do this by adding the series you want to the "Category Names" section in Analyzer