topic Re: Location details in App Development

Location details

Raju_6952 — Sun, 24 Dec 2023 15:09:08 GMT

Hi,

I have data related to sensors and incidents,here the sensor create incidents and based on that sensor we are extracting location details like city, facility.now problem is that some sensors were being deleted by which the incidents created from that sensors becomes null as the location details for that sensors were not available as the base sensor has been deleted. Is there any way to show that incidents as "others" location in addition with the main available location data.

Sample data:

City incident count

Bangalore,150

Chennai,200

-,100( this count because of sensor deleted as we don't have location details).

I need to show that as "Others -100"

Thanks in advance ,

Re: Location details

Gabbar — Mon, 25 Dec 2023 04:21:58 GMT

Use Coalesce:-
Coalesce(City incident,'Others') as "City Incident".

It will change every null value in table to 'Others'.
Also please check if the value is null, blank o '-' before using coalesce.
If it isnt null please convert it to null.

Re: Location details

anat — Mon, 25 Dec 2023 13:53:37 GMT

if([City incident]='-' or len(trim([City incident]))=0 ,'Others',[City incident]) as [City incident]

Re: Location details

Raju_6952 — Mon, 25 Dec 2023 14:19:48 GMT

Hi,

its not working beacuse city filed dont have nulls,if I add city and Incidnet count as measure, then its generating null value for some count, in that case i need to show that as "others".

Thanks.

Re: Location details

Or — Mon, 25 Dec 2023 14:42:01 GMT

In your original post, you describe City as being null. In your second post, you say is does not have nulls. It may be helpful to better explain your situation and provide an example that matches in order to get answers that will help you solve the issue.

Re: Location details

Raju_6952 — Mon, 25 Dec 2023 14:50:04 GMT

City | IncidentCount
-------------|--------------
New York | 150
Los Angeles | 120
Chicago | 90
Houston | 80
Miami | 60

-| 100.

This is the output when I add city as dimension and count (distinct IncidentID) as measure.

Re: Location details

Or — Mon, 25 Dec 2023 14:52:20 GMT

There are two suggestions above on how to deal with the nulls in City. It does not appear you've tried them?

Re: Location details

Raju_6952 — Mon, 25 Dec 2023 15:02:53 GMT

Hi @Or ,

I tried them but no use.

Thanks,

Re: Location details

Or — Mon, 25 Dec 2023 15:09:52 GMT

Using your exact data, and one of the suggestions above, I seem to be getting the desired result...

Load if([City incident]='-' or len(trim([City incident]))=0 ,'Others',[City incident]) as [City incident], IncidentCount INLINE [
City incident, IncidentCount
New York , 150
Los Angeles , 120
Chicago , 90
Houston , 80
Miami , 60
, 100];

Re: Location details

Raju_6952 — Mon, 25 Dec 2023 15:15:04 GMT

Hi @Or ,

Thanks for the update,

Will check on my end.