cochoa Member

Thank you! I was calculating everything correct but on the state map I was trying to count just by county and it was throwing my numbers off when I had duplicate county names. I changed it to county by StateCounty and so far so good. Appreciate the time and help!!

Ok, I am back with one more shot at trying to figure this out. (Note: All raw data is by individual event within a state and county by file. Raw Data. If that matters.) I have a beastmode that states: CASE WHEN (SUM(fail_events) / SUM(total_events)) > 0.5 THEN 1 ELSE 0 END (Failed events are by file and total events are…

It's a bit tough to explain but I will try. I want to use the native map of the US that shows the states but on each state I want it to tell me how many counties within that state met a particular failure rate. If in California, I have 15 counties that had failed a measurement, I want to see the state with a 15 as the data…

Thanks! Will try that out.

I would love to know if you hear anything on this!

"Eventually, we intend to make Grid Lines a user-level default that will follow the user from DataFlow to DataFlow, but that is a future enhancement." Are there any plans to make the grid lines default to always show at an instance level? Or will this only be at the user level?

My set up: Sample of one of the beastmodes on my series. (They are all the same.) CASE WHEN PRODUCTIONBY <> 'NPS' AND SLAStatusAverage <> 'Within SLA' THEN AVG(DAYS_CUSTOMERVIEW) END Example: FL is shown twice and not grouped together. I am not sure if this is enough detail for you to help but thanks!

Thank you @david_cunningham ! I knew there was something I could do but still learning. :) This pointed me in the right direction. Still some tweaks I needed to do with my data and use nested calculations but it worked! Appreciate the help!