MichelleH Coach

@jtrollinger I would check your sorting settings in Analyzer. If you are sorting by multiple fields, be sure that this is the one at the top of the list. Also, be sure that you are not sorting by the SUM of the sort field.

@TripleZ I agree with Mark's solution. You can also try using the below formula in a filter tile to check whether the value has only numeric characters. The REGEXP_LIKE function will return 1 if it matches and 0 if it does not, so you can specify that you only want to keep the matches REGEXP_LIKE(`Part`,'[0-9]*') = 1

@ColeStuart I can't speak to the other features, but subset processing is live in MagicETL already

@bennett_for_you You will need to swap which fields you are using in the X-Axis and Series since the legend is based off of the "Series" field. Alternatively, you could create a separate card for each metric and arrange them in a dashboard with the metric name in the title instead of relying on a legend.

@shreeyab Can you please share some screenshots of what you're seeing?

@shreeyab Here are a few things to check if your drill path is not working as expected: Apply the same filters in the Data tab of the dataset to see which rows should be included in the drill Be sure that you are clicking on a dimension when you drill, not the measure, since that field is what is used to filter the drill…

@jtrollinger If you put SUMs around the numerator and denominator of your beast mode it should provide a weighted average in your total and subtotal

@shreeyab What specifically didn't work? Do you have screenshots of the behavior?

@Ellier You could try using FIXED functions with filter allow/deny parameters as your measures so that they filter independently.

@AO3 The error is likely due to using NULLIF instead of IFNULL at the beginning of your function. If it is still giving you issues after that, then I'd suggest reformatting your function to an AVG window function with 12 rows preceding instead of 12 LAG window functions.

Great idea! It would make sense to include this in the Data Handling section of the Input Dataset tile.

@joecanning It looks like federated datasets don't support Dataset Views, according to this KB Article:

@joecanning Can you elaborate a bit more about what you're looking for? Are you using Dataset Views or Redshift Dataflows?

@RTData Yes, you will need the Domo for Office Add-in. You can find the link in your instance under Admin > More > Tool Downloads.

@Ellier You'll likely need unpivot your data so that "Ramped Headcount" and "Partially Ramped Headcount" are on separate rows. Then you should be able to use a simple quick filter/slicer instead of a variable

@PJG If you use a beast mode to force the sort order, you can still use the original field in your bar labels as long as the beast mode is in the sorting section of Analyzer

@carthur Are you applying any other filters to your card that could be excluding more recent data?

@carthur This is not currently an option, but I've seen this suggested in the Ideas Exchange. I recommend upvoting those posts to get some more attention behind the idea.

@Laura_M1 The drill does not give you the option the change the date range because it will automatically inherit the date range of the layer above it. So if you have the top level set to the date field and range that you want, you do not have to do anything on the drill to match it.

@nmizzell Unfortunately there is not much flexibility in the labels for Period Over Period charts. If you want to change it to a static name, you will have to switch to a different chart type and use a beast mode instead.

@jtrollinger Can you share some more details on what specifically isn't working and what values you're expecting? Also is your data aggregated?

@PJG Yes, you would still use the Totals option but set the Aggregation for that column to Average instead of Sum.

@lemon76 According to this KB Article Adrenaline dataflows are capped to a 30-min timeout. You may need to adjust your query to shorten the run time.

@Jarren What steps did the user take before getting the error? I have not seen this error before, but I suggest checking whether the user has the "Download Workbench" grant.

@HCyamada How is your data currently structured?

@Laura_M1 This is likely related to the same conflicting filters issue from before, and there are no Sales Locations left in the filtered data. As a side note, you don't have to Select All before toggling "Display as Quick Filter" - in fact I recommend you don't. In this case Select All does not include every possible…

@JedP This is super helpful, thanks for sharing!

@Laura_M1 Is this what you see when it doesn't give the option to select all? If so, you should be able to change the drop-down from "Match values" to "Selection" to give you the checkboxes:

@Laura_M1 I don't think you need to start again from scratch, but I would at least start by removing all the filters from the drill path. Since drill filters are inherited from the layers above it, I find that it's easiest to only add filters to the top layer whenever possible to avoid accidentally excluding data when I…

@Laura_M1 I see. That means that it is drilling, but the filters applied make it so no data is returned. Do you have any filters set on your final drill that are not on your previous layers?