MichelleH Coach

@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:

@haipham What specifically didn't work? Did you receive an error in the ETL or did it return an incorrect value?

Hi @Abe, would you be able to share some sanitized sample data with an example of how you want the output to look?

This is a cool idea! It would be great for standardizing logic and helping new users get up to speed.

@Sbhatia The reason the total is showing a count is because the actual calculation is occurring within the CONCATs in your case statement, which means the that "Visits vs Prior Week Colour" field has a string datatype. If you want to conditionally color the column and have a total row, I suggest using Domo's built-in color…

@WorldWarHulk I agree with all of @ArborRose's suggestions. I would also recommend checking the activity log for User Renaming events that have occurred, which may give you more information on what is going on.

@WorldWarHulk Do you use Single Sign On to provision users?

@WorldWarHulk Are you changing their name from their profile in the Admin People screen? Is it possible that you are not clicking save?

@kim_barragan0126 Yes, that would work!

@levi_kim This will largely depend on your data and how it's ingested in Domo. For example, are new rows added a day/week at a time where you can use an ETL to add a relative date field to the new rows? It will also be helpful to review the other columns you have available that could be used to infer a date, like period or…

@kim_barragan0126 It looks like the parenthesis around the value are preventing it from converting to a floating decimal. You will have to remove those characters before converting the datatype using a formula. Do you know if the parenthesis represent a negative number, like in an accounting format?

@dkonig Which Adobe Analytics connector are you using? Some have partition capabilities in the connector itself.

@Eric.P Depending on which type of statistical test you are running, you could potentially recreate the base p-value calculation in beast mode. Admittedly, that would be a pretty complex calculation, though I do see that there is a standard deviation beast mode function.

@Stu5677 What have you tried so far?

@DataLyd The dataflow will continue to run on the original schedule even if you manually run it.

@TMonty0319 What does your original data look like?

@har_d_har1 Before you do that, I recommend reading this Knowledge Base article on Gantt chart cards, which provides guidance on how to structure data for these types of visualizations:

@har_d_har1 I generally advise against pivoting by date in a dataflow because it is very cumbersome to manipulate a constantly growing number of columns. May I ask how you intend to use this data so we can suggest another transformation method?