MichelleH Coach

@ColinHaze If you are using MagicETL, then I recommend using the SPLIT_PART function in the Formula tile.

@chetan_cricut Does Q4 have records in your dataset with more than one value for Content Type ES Quarterly-2? If so, I'd recommend wrapping a single AVG function around your entire case statement instead of around the individual conditions to avoid issues with granularity.

@Josh_Evans20 It's greyed out on the drill path because it inherits the date range from the top level card, like other drill filters.

@DomoATX I would recommend adding an "Add Constants" tile to all 8 branches of the dataflow before they all merge into the "Append Rows" tile. Be sure that the column name in first step is the same for every tile. The only difference between the the tiles should be the Source Name in the third step.

@Utz Could you please share some screenshots of what you are seeing when you apply the filter?

@Jbrorby Is she able to see the report when opening the email, or is it just in the inbox preview? This appears to be an Outlook issue. Domo Scheduled Reports use HTML to display cards in the body of the email, which is consistent with the strings appearing in the emails.

@a10hall There is a separate scheduled reports screen in the Admin settings that provides access to all scheduled reports in the instance. That said, there is definitely opportunity to improve this since the list is only searchable by report name and not owner.

@Abby Brinks The line + grouped bar should work. If you want to display 2 lines, you can add a "2" in the "Series on left scale" setting under General chart properties

I am running into the same issue when using a different dataset on a drill path. I often don't think to share the dataset with the users on the dashboard and only find out when one of the users reports not being able to see the drill data. It's also difficult to verify that the drill works for everyone else on the…

@Data_Devon I would suggest going the append route for this data and adding a Category column to indicate the source of each row (Budget, Financials, etc.). Then you can use beast modes to present the output in a single card like this: Budget Revenue: sum(case when Category = 'Budget' then Revenue else 0 end) Actual…

@HowDoIDomo You could also consider the Campaigns App, though you may need to reach out to your CSM if it is not available in your instance

@agolla2 Beast modes don't typically work well with aggregating aggregate/window functions. I'd suggest calculating the LEAD function in an ETL so that you don't have to do it in beast mode

Are you using the Google Sheets connector? You could try forcing that column to a string in the connector and using the STR_TO_DATE function to transform it back into a date field in the correct format

@Kaminora Is your variable referenced in any beast modes that are actively being used by the card? If it is and it's still not appearing in the card then I would suggest reaching out to Domo Support.

@user046467 Can you confirm that your field is actually stored as a date in Sheets and not just text?

@SameerSarnad From what I understand, Forms are not automatically enabled in your instance with App Studio. I'd suggest reaching out to your CSM or using the Form Brick in the AppStore.

@HowDoIDomo I'm not aware of any settings like that, but I did find a helpful formula that adjusts for daylight savings:

@HowDoIDomo I would check the timezone of the dataset used for the view. If it is not the same timezone as your instance, it may be trying to convert it.

@M_A Can you please share an example of the result you are receiving and the desired result so we can understand what specifically isn't working?

@mroker Those are the columns in a dataset history, not a dataflow history. The dataflow is what shows the storage used.

@mroker If this is a one time import of historical data, then appending would likely be simpler than partitioning.

@mroker If your dataset is used as an input or output of a dataflow, then the dataflow history tab will show the number of rows and storage used for each dataset.

@mroker Where is your data currently stored? Depending on whether it's a spreadsheet, ODBC, cloud, etc. there are different connection options available. If importing all the rows at once is an issue, then you may need to upload in batches and appending the batches onto each other.

@Data_Devon I'd suggest using a tooltip for your data label instead of the default macros. Then you can create the percentage in a beast mode and add that to the tooltip1 field in analyzer.

@bjackson1990 I would suggest using a Group by tile in Magic ETL to find the maximum of CALDAYFORMAT and call it MAXDAY to represent the most recent date in your dataset. Then you can use the beast mode below to calculate prior year YTD: sum(case when YEAR(`CALDAYFORMAT`) = YEAR(`MAXDAY`) - 1 and DAY(`CALDAYFORMAT`) <=…

@PJG You will need to add IFNULL around every value in your beast mode to force nulls to zero like this: IFNULL(Value1,0) + IFNULL(Value2,0) + …

@Mukhilan I'd suggest calculating the "Week of Month" using the Calendar dataset from the Domo Dimensions Connector, then joining by date into your spend dataset

@deona720 I believe Hyperlinks only work in table cards because the default raw data view does not read the HTML. If you haven't already created the cards you need to drill, you can set up the drill path for one card, copy the card as many times as you need using "Save As", and only edit the top level cards as needed. This…

@JasonKerr I mean to use the FIXED beast mode in place of the existing value field. By using the FIXED aggregation, you are dictating how you want the grand total row to calculate instead of the default aggregation.

@JasonKerr Try using a FIXED function in your beast mode and put your row and column fields into the FIXED BY clause. Here is an article on FIXED functions: