user10986 Member

Thanks - the Google Map Brick seems to operate very differently than Google Maps. It seems to show # of pins in a circle when you zoom out vs. if you plot the same information on Google Maps, it provides actual pins overlapping each other which is more desired.

Right now - I'm just emailing it in each day which is not ideal. When I try to use the instructions - I get the following error - AADSTS50194: Application '87d93786-5475-4efe-bf97-13c4ecd32d5f'(Domo+Sharepoint) is not configured as a multi-tenant application. Usage of the /common endpoint is not supported for such…

Hi - thanks for the reply. It did not work though. I've attached the formula and what the chart looks like using that formula. I also attached the baseline chart - that has everything except the dropout rate (line). Any help would be greatly appreciated.

I think the logic is helpful enough - I think I will have to add some data validation to the front end.

Got it - I will look at the case logic - from your last note - I got the following error: "Failed to convert value '22/04/18' from type 'String' to type 'Date'."

It keeps erroring out noting "Failed to convert value '005/27/22' from type 'String' to type 'Date'." I then added to your formula DATE( replace(REPLACE( REPLACE(`Interview Scheduled Date`,'/','-') ,'.','-'),'00','0') ) But I got this result, "Failed to convert value '05-27-22' from type 'String' to type 'Date'."

Actually the dataset errored out - let me investigate further.

DATE( REPLACE( REPLACE(`Interview Scheduled Date`,'-','/') ,'.','/') )

Thanks - that worked for most of the entries - but now all the ones that had 22 as the year vs. 2022 still aren't showing up well. So I'm left with the remaining formats: 22-5-20 22-2022-05 I thought about doing a replace on 22 to 2022 but I'm afraid that will impact 5/22/2022 items.