How to identify the country name based on the time zone available in the column?

[sspk]

Hello Team,

I have a table name called 'meta' and has information about 'timezone' column. I have to identifiy the country name based on the dynamic timezones available in the column.Ho w to do that? How to create a new Column in the table itself to identifiy the country name?

or 

Should i create a new table with country name represents timezone and country as table 'world_time' and map the new created table  'world_time' to table 'meta' with one to many(world_time(1) ---> meta(n)).

Idea is to identifiy in which country how many user has clicked. Column 'user' is just usename of the each user clicked.

How to do either one in PBI?

Thanks and Regards

Siva

[PhilipTreacy]

Hi @ssspk 

There is no way to identify a country based only on a timezone.  Many countries share the same timezone.  Some countries span many timezones.

You can't do what you want if you only have a timezone, you need some other information to identify a particular country.

Phil

[ssspk]

Hi @PhilipTreacy 

Thank you for your reply.

I have a n idea to create a new Table with Column Country/Location/ Continent (Europe, Asis, America,Oceanic) and colunm timezon.

Based on that i can use the Filled Map component. where it displays all continent in different colours and on mouse over i can sum all the Count of the clicks and display it over all by Continent wise?

What do you think about the isea? How we can do it?

Thanks and Regards,

Siva

[PhilipTreacy]

Hi @sspk 

I'd do Option 2, create a table with the timezone and country name.

However the problem is that more than 1 country will have the same timezone.

You will also have countries that span more than 1 timezone.

How do you intend to solve those problems?

Regards

Phil