MichelleH Coach

@Cintia It looks like you are sorting based on a COUNT of both of your fields. Try changing the aggregation to MIN instead.

@Cintia Can you please send a screenshot of what you see in analyzer (hiding any sensitive info)?

@Cintia In that case, you would need to sort first by MIN of `Snapshot` then by this beast mode: case when `Series` = 'Implemented' then 1 when `Series` = 'Firm' then 2 when `Series` = 'Potential' then 3 end

@Cintia Is `Snapshot` already being used on the X-axis of your bar chart? If so, you shouldn't need to sort by date since Domo should already know to sort dates chronologically. If you are sorting by other fields as well, that could potentially mess with your date sorting.

@eduardon A case statement inside a count function should give you what you need: count(distinct case when `Status` = 'Active' then concat(`Month`,`Client`,`Country`) end)

@kathint303 If you create a table card of the data you want to send and create a scheduled report of that card, there should be a check box in the report schedule settings to include a CSV attachment. Is that what you're looking for?

@ggountanis You can add the percent of total under the Data Label settings in Analyzer by writing %_PERCENT_OF_TOTAL in the "Text" box to make it appear in the card

@MB_Dem By default any dataflow output datasets are owned by the user who owns the dataflow, even if both users have access to all the input datasets. The owner of the dataflow will need to share both output datasets with you.

Agreed. Forcing inputs to a particular datatype would also be a useful enhancement

@BenjaminPapes I'm glad that worked for you! As for your other two issues, I'm not aware of any way to accomplish what you're looking for, but those would be great suggestions for the Ideas Exchange.

@Joyce The reason this issue occurs is because changing the filter excludes the rows necessary to complete the calculation since your beast modes are written to only calculate results for data from the past two weeks. In other words, when you filter to more than 2 weeks ago there are no rows being included that satisfy the…

@damen I'd suggest using the STR_TO_DATE function in the formula tile. Since there may be 5 or 6 digits, you can use the LPAD function to add a leading zero if the length is less than 6. STR_TO_DATE(LPAD(`DUE DATE`,6,'0'),'%m%d%y') Here is the KB article with all the date format specifiers to use with the STR_TO_DATE…

@BenjaminPapes It was worth a shot at least. Another option would be to create a global variable where the user can select a year to replace the max date like this: sum(case when YEAR(`Sales_Date`) = `Year_Variable` then `Sales` else 0 end)

@BenjaminPapes I see what you mean. The error you're encountering is because your calculation has an aggregate inside and aggregate. Does it still give you an error if you remove the outer SUM from the beast mode and set the aggregation in the drop down when using it in the card?

@Stuck I agree that this would be a good request for the Ideas Exchange. You could also consider using a cross-join in your ETL if it's too cumbersome to manually filter 20 projects.

@BenjaminPapes If you don't want the maximum date to be affected by dashboard filters, I'd recommend adding it as a dataset column in your dataflow instead of a beast mode. That way it will not be affected when you filter by sales date.

@Stuck That's an interesting use case. The best way I can think of to accomplish this is to create an "anthithesis" dataflow for that particular card. You can do this in MagicETL following these steps: Add a filter tile to exclude all rows for a particular project (e.g. bananas) Rename the field that is used for the…

@kodonnellLT Both of these queries are returning syntax errors because you need to specify which field needs to be greater than 111 in your case statement. In other words, it should look something like this: CASE WHEN "Status_c" in ('Booked') and "FieldName" > 111 then 'TIER 4' ELSE 'TIER 1' END

@swilliams If you need the data to be in a PDF you could try exporting to Excel and then re-saving the .docx as a .pdf file

Hi @Stuck are there other dashboard filters that you want to apply to these cards? If not, I'd suggest disabling the filter interaction on those cards. You can do this under Edit Dashboard > Card Options > Change Filter Exceptions > Allow Filtering

@Marcy Try using CUR_DATE() instead of CURRENTDATE()

@Marcy It looks like you were using a greater than operator instead of less than. In that case you wouldn't need the month condition. Here is what it would look like: case when `Completetion Date` <= CURRENTDATE() then 'Include' else 'Exclude' end

@thwartted Can you please post an example of how your data is structured?

@NathanDorsch In the Trigger Frequency settings, it sounds you have it set to "Only when Datasets are updated" and have every input dataset checked. Instead, uncheck the boxes for all the datasets except the one you were concerned about not capturing the updates due to timing.

@user028582 Can you please share an example of what your data looks like and the desired result, removing any sensitive information? That will help us answer your question more effectively.

@MB_Dem Do you have any time-based filters on your card that would result in no data being visible in the card that the time the report is scheduled to send?

@NathanDorsch Have you tried modifying the dataflow updated settings so that your updates don't overlap? You could either set it up to run on a schedule or have it set to only run once the last dataset has updated. That could save you the headache of redirecting the ETL outputs.

@jrtomici This is a common issue that has to do with how nulls are handled logically. You can get around this by creating a separate beast mode for your filter like this: ifnull(`field`,'Filter out')

@Stuck A couple other things to consider: Does your custom sorting beast mode take into account the null handling used in your value field? If you have multiple sort fields in your card, are you able to achieve the desired behavior by rearranging the order that the fields are listed? If neither of these get you what you…

@Stuck Can you elaborate on how you "force sorted"? You can create a beast mode to create a custom sort order like below: case when X then 1 when Y then 2 when Z then 3 else 4 end Also, can you check that the aggregation used in your sort fields aligns with the aggregation of the same fields in the pivot table? If any of…