![]() ![]() ![]() ![]() Iv) Automatically combining latitude and longitude values into a POINT fieldĪfter selecting the fields and converting a few data types, we analyzed the burglaries data set and came up with a dashboard below: Ii) Strings to a chosen date format (even Epoch time) At this stage, you can also reformat the chosen fields into the desired data types for easy reporting which includes: This then opens the JDesigner which allows Yellowfin to scan the JSON schema to extract the keys/fields for analysis. P aram List: $limit=10000&primary_type=BURGLARY Using the JSON Connector in Yellowfin 7.3+, we generated a token, provided the details below, and validated the JSON end point: ![]() To provide a more focused story, we narrowed it down to burglaries. We decided to connect to the 2017 Chicago Crime data set via the Socrata Open Data API (SODA) which provides additional abilities to filter, query, and aggregate as needed. Since crime is a hot topic in the US right now, we looked at a few JSON API feeds and came across the Chicago Data Portal which houses data collection in various categories, one of which is crime. Today, we’ll discuss a different method which is connecting to a JSON API endpoint. For our recent Yellowfin 7.3+ launch, we showcased the JSON connector directly accessing a real-time GeoJSON feed of earthquakes around the world from the USGS Earthquake Hazards Program, and plotting them onto a map. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |