MichelleH Coach

@MDavis I agree with @MarkSnodgrass' suggestion. One thing to look out for on this is that you can choose any dataset to power your card, but you will need to set it up so that there is always at least one row of data included in the card. For example, if you have a date field filtered to "Today" but there is no data…

@Patrick_Cruz You will need to select every possible variable value using the control within Analyzer, then add the color rule for that specific value. In that case, be sure to set the control back to the default value before saving the card. Admittedly this process is not ideal, but requesting a quicker solution would be…

@NIKKI The Graphy by option is only available if you have are using a date column in your card, so it is not showing up for you now because Location is currently in the X-Axis instead of the date. I'd recommend keeping the Location in the X-Axis and Total Hours in the Y-Axis, but adding a drill that uses your date field to…

@froghunter The divider width cannnot currently be changed, but you can request that feature in the Ideas Exchange.

@lfielding I second @GrantSmith's suggestion about using a Sankey chart since it's designed for visualizing these types of relationships and would eliminate the need for so many clicks. You can still drill down to see specific names in a table format. An alternative is to create a dataflow that joins employees of each…

@NathanDorsch Try this: .*RMP.* For future reference https://regexr.com/ is a great resource to test whether your Regex works as expected

Agreed! The min/max would also be helpful for numeric variables, especially in cases where negative values shouldn't exist

@chetan_cricut If you are an admin you can bulk delete under Admin > Content > Cards. You should be able to narrow down the list to orphan images/notebook cards using the filters below, then select all and delete

@ActivelyLearning123 I don't believe there is a chart type that allows for multiple points, but I've been able to accomplish something similar by structuring my data so that each row represents a "leg" of the route and using a route name as the series for coloring. Here is an example of how to structure the data:

@Jobur I'm glad you got it to work in the dataset. Yes, I've found that calculated columns don't always perform well in dataset views, especially when columns or removed or grouped.

@NIKKI Would you be able to share a screenshot of your raw data and beast mode results, hiding any sensitive information?

@Jobur Just to confirm, are you adding this formula as a calculted field in the view or as a beast mode in the card? It may be worth trying the opposite method to whatever you did before.

@NIKKI Does the Result column value match 'Non-Compliant-Urgent' exactly?

@Jobur Are all of the fields referenced in your formula in your final grouped output?

@NIKKI Do you plan on having a single row per value of the Indicator Text field? If so you do not need to partition by that field in your card because your data will already be grouped by that field. Also, note that your denominator will always be 1 in this case based on your current formula. If that's not what you want,…

@NateBI It looks like it MagicETL may not support LISTAGG(DISTINCT), even though it is a valid SQL statement. As a work around, I'd suggest creating a separate branch of your ETL before the Group By that filters out duplicate values according to all your group by fields and RESOURCE_NAME. Then you can run a parallel Group…

@NateBI Are you using a Formula Tile or a Group by tile? The LISTAGG function will not work in the Formula Tile because it is an aggregate.

@Lowell_Walker Option #2 usually works well for me, except for if I need to make changes after the drill path is created. Can you share some more details on where to find the "Copy to Drill Path" and "Edit All" features you're referring to and whether those are available to all customers?

@NateBI What does the error say?

@chetan_cricut You could still set up multiple alerts on the same card based on the sum of each dataset field as long as the card is filtered to the current week

@chetan_cricut The best way to do this is to set up your summary number to display the sum for the current week, then set up the alert to check weekly for a certain % change based on your summary number value

@chetan_cricut How are you defining % change without aggregating the data? Can you share some more details on what you are trying to accomplish?

@NateBI Yes, you can add DISTINCT inside the list_agg function the same as you would to for a distinct count like this: List_Agg(DISTINCTcustomer_name, ' / ')

@Stemiller Do you have a field in your dataset that flags the most recent date or would the most recent date always be today/yesterday/etc.? If so you could aggregate your snapshot data in a beast mode like this: max(case when Date = CURRENT_DATE() then Inventory on Hand end) or max(case when Last Date Flag = 1 then…

@BonnieAnn If you are using MagicETL, there is actually a function in the Formula Tile that does this for you called DATE_WORKING_DIFF(). I'd suggest giving that a try to see if it works for you.

This is a great idea to avoid the endless scroll in Webforms

@ekishab That makes sense. I would have suggested using a chart type with a heatmap, but that would not help with a categorical series. Unfortunately I am not aware of a way to mass update color rules, though with 20+ you may want to just use the default colors.

@ekishab What kind of chart are you using and how complex are the conditions?

@lb1234 What method of comparison makes the most sense for your business? Would you want to exclude days 29 through 31 of the current month, or something different?

Hi @Manasi_Panov in order to compare values from different rows, you will need to first use LEAD function in a Rank & Window ETL tile (https://domo-support.domo.com/s/article/360044876094?language=en_US) to identify the values of Work Type and Order on the row above. Then you can use a CASE Statement in a Forumla tile like…