Best Of

Your AND statement is slightly off. You are also missing an END statement inside the count. You have to re-state what you are evaluating, like this:

CASE

WHEN COUNT(case when `FirstSetupApprovedDate` IS NOT NULL then `CaseID` END) >= -1 AND COUNT(case when `FirstSetupApprovedDate` IS NOT NULL then `CaseID` END) <= 10 then 'Povider 1-10'

WHEN COUNT(case when `FirstSetupApprovedDate` IS NOT NULL then `CaseID` END) >= -11 AND COUNT(case when `FirstSetupApprovedDate` IS NOT NULL then `CaseID` END) <= 20 then 'Povider 11-20'

end 

You might also consider moving the case statement to the very outside, which might work better:

CASE when `FirstSetupApprovedDate` IS NOT NULL then
(CASE WHEN COUNT(`CaseID`) >= -1 AND COUNT(`CaseID`) <= 10 then 'Povider 1-10'
WHEN COUNT(`CaseID`) >= -11 AND COUNT(`CaseID`) <= 20 then 'Povider 11-20'
end)
END

Hope this helps.

If I am understanding you correctly, you could make a percentage beast mode for each type, like this:

Easy Client Pct: Easy Clients / Easy Clients + Medium Clients + Hard Clients

Medium Client Pct: Medium Clients / Easy Clients + Medium Clients + Hard Clients

Hard Client Pct: Hard Clients / Easy Clients + Medium Clients + Hard Clients

You might also consider using the Unpivot tile in Magic ETL, so that your data is restructured to something like this:

PM Client Type Count

Jim Easy 53

Jim Medium 23

Jim Hard 11

John Easy 12

....

Here's the KB article on the Unpivot tile if you haven't used it before.

https://domohelp.domo.com/hc/en-us/articles/360044951294-New-Magic-ETL-Tiles-Pivot#3.

That appears to be a limitation of the combo box card type. I would actually submit this as a bug, because it should at least match the width of the component when the text is that long. You can send an e-mail to support@domo.com to let them know of the issue.

It's probably not the detail drilled map you are wanting, but if you use the global map again as your drill path card and select auto zoom to data in the general properties, it will zoom to the country that was clicked on. However, it won't have the detail of every state or province of that country.

You can look on the internet for an svg file of a world map that has all states/provinces for every country defined on it and upload that as a custom chart. If you're unfamiliar with custom charts, I've created a video about it here: https://www.youtube.com/watch?v=SHnXk9LtK7s

Another option is to create a dashboard page that has the global map and then individual country maps around or below it.

I just did a search for "svg global map with states" and it took me here https://morioh.com/p/1ed2ddd34690 and I downloaded the big map at the bottom. I have attached it for you. You'll have to look through and see everything is properly labeled. You can edit the svg with Inkscape, which is free, or Adobe Illustrator.