MichelleH Coach

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

@Laura_M1 What you are describing should work regardless of whether you are using charts or tables. When you try to drill on that particular card, does it show you a particular message or does it simply not react at all?

@Laura_M1 It sounds like a granularity issue. Is your measure a dataset field or beast mode? Also, if you have any sort fields being used in your card I suggest removing those

@Laura_M1 Is the second level detail you're trying to see defined as a drill layer in Analyzer or the default "Data" view? If it's the latter, then drilling to it is only an option on from the card details view and not from the dashboard. In that case I suggest adding a Table chart drill layer so that it is visible when…

@user10570 Are you using beast mode or MagicETL to rank? Can you share the details?

@kenyayvette Yes, the Accounts section of the Data Center it will show how many datasets are associated with that account. If you hover over "DataSets" on the right side and click "Change Owner" you should see a new dialogue to either transfer the datasets to a new owner or new account.

@kenyayvette Do the users have the same database access? If so, is the user with the working account able to share the Domo account with the other?

@jroach The Dataset via Email connector includes a column for the input filename, so it may be worth trying that

@jtrollinger Is SourceCode = CO in the rows in question? It likely has to do with your last IFNULL forcing the output to zero

This would be nice to have to make tables a bit cleaner

@dmurgit1 Depending on your use case, you may be able to use two variable controls and a beast mode filter to accomplish this. You would have to set the values of each variable for all possible values of the corresponding field, so this would only be feasible if your fields have a fairly small and static list of values.…

@RayRay_H It looks like there may be a space after the date in the error message. Try replacing the spaces with an empty string before using the STR_TO_DATE function STR_TO_DATE(REPLACE(`Date`,' ',''),'%d-%b-%y')

@BigWave If you are using a Line Bar chart you can set a min and max value for the lines under Value Scale (Line). Since this chart type only sets the first series as a line, you can specify two lines using Series on Left Scale under General Properties

@jrudd Unfortunately, color rules only apply to fields that are actively used in the card. As a work-around, I suggest changing your card to an Overlay Bar chart and creating a separate beast mode measure for each Scoped Hours Progress value. Then you can create an "is always" color rule for each beast mode.

@ChrisGaffan How are you presenting this field in your card? Sometimes sorting can interfere with how the cards react