Re Opening Splunk Data sent to Tableau using WDC was only sending data through String (Date Values are also sent as strings)

splunk / splunk-tableau-wdc

Splunk Tableau Web Data Connector (WDC) Example

Apache License 2.0

20 stars 13 forks source link

Re Opening Splunk Data sent to Tableau using WDC was only sending data through String (Date Values are also sent as strings) #21

Closed praneeth2968 closed 4 years ago

praneeth2968 commented 4 years ago

Recent fix fixed the number and string type. But Date in splunk is coming as Number and String only even if the field was date.

Below SPL Query is the proof | makeresults | eval stringTime=strftime(_time,"%c") | eval TypeEpochTime=typeof(_time), TypeStringTime=typeof(stringTime)

![Datatype Issue] (https://user-images.githubusercontent.com/25930565/67003950-cb046b00-f0fc-11e9-8d5e-de34676bee68.PNG)

mayurah commented 4 years ago

You can use Tableau's built-in function to convert string to data-type you intend to have for analytics.