Splunk Data sent to Tableau using WDC was only sending data through String (Date and Numeric 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

Splunk Data sent to Tableau using WDC was only sending data through String (Date and Numeric values are also sent as strings) #13

Closed pmslssr closed 4 years ago

pmslssr commented 5 years ago

While sending data I want to send the data which is in the numeric or date form to be in the same format in tableau. Currently, It is sent as a string when checking in tableau. Please let me know if anything can be done to send in the same format (Number as number and string as string)

mayurah commented 5 years ago

@pmslssr This can be done by evaluating data type and changing them in JS.

I will let someone in community pick that as "good first issue".

pmslssr commented 5 years ago

Can you tell which JS should be changed in order to make sure that datatype is handled properly and sent as the same to Tableau end?

mayurah commented 5 years ago

@pmslssr

[ ] Here is the specific line which assigns dataType: https://github.com/splunk/splunk-tableau-wdc/blob/master/src/splunk-wdc.js#L206
[ ] Might help as a start on how you can detect data type in JavaScript: https://stackoverflow.com/a/175787/866571
[ ] Detect datatype before assigning
[ ] Assign detected datatype

dataType: tableau.dataTypeEnum.string

pmslssr commented 5 years ago

@mayurah JS was updated two days back. Now, Can you refer to the exact line where it is assigning data type?. It will help us a lot

mayurah commented 5 years ago

@pmslssr Updated comment with new line number and code sample which deals with datatype.

pmslssr commented 4 years ago

@jrzmurray Shall I pull WDC again so that it will solve this issue when I refresh from tableau end ?

jrzmurray commented 4 years ago

@pmslssr you can pull my forked version now (source of the PR), or wait for this PR to be merged.