Whispering Technology
Tableau Prep or Tableau does not have A built in rest API connector, but we can download data from rest API using Power Shell and pass it to Tableau Prep Flow. We will be using IEX Share price API for the purpose of this demonstration. Try the below one liner...
Handling numbers as text for the first time in Tableau is a frustrating experience. Depending on your requirements, you might have to add /remove trailing/ leading zeros, modify number of decimal places etc. This post is an attempt to address the most common scenarios. Note: If the final result required...
If you have a folder where files are added daily, how do you load the latest file automatically in to tableau? I recently answered a stack overflow question and this post is an attempt to explain the other aspects that is not covered on that answer. Basic Setup If you...
The default map in Tableau is good for showing overall locations, but it cant be used to zoom in to specific streets or buildings in your locality. But dont worry, you can use Open StreetMap for that. Download this file and save it under Mapsources folder in your Tableau repository. Default location...
My home state is going through a crisis right now as the largest arch dam in Asia , Idukki Dam is reaching its full reservoir capacity due to unprecedented monsoon rains. All 5 shutters were opened on 10th August and is still releasing water at a rate of 0.75 million liters ...
Recently, I had to create one status dashboard for a JIRA project. Tableau does not connect to JIRA out of the box and you need to purchase a connector to get this functionality. Since JIRA has a REST API, my initial instinct was to build a web data connector. But ...
Common way of putting text and shape in a single cell in Tableau uses Shape as mark type and the value as Text. Increase the column width and you have a somewhat usable view. In the above example, I am using a dummy status calculation for color and shape selection....
Tableau allows to connect to a wide variety of database systems and most of the operations like joins, filtering and ordering can be done without writing a single line of SQL. But what can be done if the data required is not readily available in the database tables? There are...