I have an excel file that I upload to a free-30 day Cloud CA account.  The excel file has Lat and Long in it, plus 19 other fields.  I created a data module from excel, I hide 4 fields and set properties on several other fields before saving it.

I then did a create exploration using the data module, the explore relationship in your data doesn't show the lat or long.  

Exploration


------------------------------
Jo Marie Sellner
------------------------------

#CognosAnalyticswithWatson

Hi Jo Marie,

Would you be able/willing to attach the data file as well?

Thanks
//Henk

------------------------------
HENK CAZEMIER
------------------------------

Hi Jo Marie,
thanks for posting your question.

The result most likely means that the data in both Lat Long is not determined as statistically correlated.

 Could you try to create a Advanced Analytic spiral visualization?

i am curious if you see long lat as influencers/drivers for you interesting field in discussion- gasSold - use it as target here.

also if u hit the ... menu in the Target field and select Edit Drivers?
 Can you check if both fields Long and Lat are recommended drivers for evaluation?

let us know!

Regards,
valentin Balteanu

------------------------------
VALENTIN BALTEANU
------------------------------

Attaching a subset of the data, Copy of 2019_01 small.xlsx.

I am able to create a map (Map.jpg)  with the data from the data module.  If I try converting it to a spiral, it says it can't use the lat and long.  If I create a spiral from scratch and use lat or long, I get a warning, see Driver and spiral jpg's. 

The Lat and Long are set as Identifiers and I have tried leaving aggregate as defaulted and changing to none, get same results.

Thanks for looking at this.

------------------------------
Jo Marie Sellner
------------------------------

Hi Jo Marie,
Thank you for your answer and for attaching the partial data file.

In the case of spiral, we need to use GasSold field as target, as we are trying to see what drives this measure/target. We want to determine if the system considers Lat and Long as Driver candidates.

I will try to use the data you attached, but the result may be different since data is used to calculate the statistical correlation.

Regards,
Valentin

------------------------------
VALENTIN BALTEANU
------------------------------

Original Message:
Sent: Mon July 15, 2019 11:50 AM
From: Jo Marie Sellner
Subject: Cloud 11.1.3 exploration help

Attaching a subset of the data, Copy of 2019_01 small.xlsx.

I am able to create a map (Map.jpg)  with the data from the data module.  If I try converting it to a spiral, it says it can't use the lat and long.  If I create a spiral from scratch and use lat or long, I get a warning, see Driver and spiral jpg's. 

The Lat and Long are set as Identifiers and I have tried leaving aggregate as defaulted and changing to none, get same results.

Thanks for looking at this.

------------------------------
Jo Marie Sellner
------------------------------

Hi,
Ok...  I have used the partial data file and I was able to build a Driver Analysis visualization using GasSold field as a Target.
Using Edit Drivers I can see the system recommended Lat and Long as possible drivers, and they were included in the statistical evaluation. Still the system has not determine any correlation between the Lat and Long and GasSold, meaning that we cannot conclude that Lat and Long would influence GasSold in a significant way.

Here is the result I get using GasSold as target with the partial data set you sent.

Also you can see that if I manually select Lat or Long as Interesting fields, none of them are reported as statistically related to other fields significantly.

Hope this helps,
Valentin

------------------------------
VALENTIN BALTEANU
------------------------------

Original Message:
Sent: Mon July 15, 2019 11:50 AM
From: Jo Marie Sellner
Subject: Cloud 11.1.3 exploration help

Attaching a subset of the data, Copy of 2019_01 small.xlsx.

I am able to create a map (Map.jpg)  with the data from the data module.  If I try converting it to a spiral, it says it can't use the lat and long.  If I create a spiral from scratch and use lat or long, I get a warning, see Driver and spiral jpg's. 

The Lat and Long are set as Identifiers and I have tried leaving aggregate as defaulted and changing to none, get same results.

Thanks for looking at this.

------------------------------
Jo Marie Sellner
------------------------------