MichelleH Coach

@Patrick_Cruz Interesting, I would expect it to work if you tried to set color rules based on the beast mode. Would you be able to share some screenshots of your beast mode and your Analyzer setup?

@Patrick_Cruz What field are you basing your color rules on? Is it the dataset field for dimension B or the beast mode that displays values of both dimensions based on your input for variable X?

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