ThoughtSpot Website

How to enable Javascript

Questions & Answers

All topics

Have a question? Ask it here. Or reply and share your knowledge.

Follow

2
how to handle multiple date formats in large csv files in tsload ?
I have a large CSV file that I'm trying to load through the tsload command line tool. I see that there's an option to specify the date format with the --date_format option.…
- michael xu
- Developer
- michael_xu
- 2 yrs ago
- 42 replies
- 1,547
- 2
- Lokesh Ceeba1 yr ago
- Questions & Answers
- Answered
- Answered
2
week to date change
I have a production date on many of my deposits. What I would like to do is to create a week to date change, a month to date change, and a year to date change giving me dollar amounts.…
- Hamza Alsalman
- Business Intelligence
- Hamza_Alsalman
- 1 yr ago
- 40 replies
- 1,168
- 2
- Hamza Alsalman1 yr ago
- Questions & Answers
- Answered
- Answered
0
Canada Geo Config
Hello my Canadian ThoughtSpot peers. Hoping you can help. I recognize that ThoughtSpot has not yet done a Geo config for Canadian Postal Codes. However,…
- Roland Schlichting
- Director, Corporate Reporting
- Roland_Schlichting
- 2 yrs ago
- 24 replies
- 908
- Monique1 yr ago
- Questions & Answers
- Answered
- Answered
0
Print or download entire pinboard
Has anyone figured out how to print or download an entire pinboard that has multiple pins on it (versus doing each one separately - painful!) Thank you, Karen
- Karen Daugherty
- Karen_Daugherty
- 1 yr ago
- 23 replies
- 142
- Ashley Mueller6 mths ago
- Questions & Answers
- Answered
- Answered
- Margie RoginskiThoughtSpotter
- Senior Manager, Product Management
- Margie_Roginski
- 9 mths ago
- 1
- Official Answer
- Reported - view
Our new PDF export will be released with 5.3, which is in our release pipeline now. With this release, you will be able export a pinboard in "pinboard format" (multiple visualizations per page,…
1
Year over Year Difference
Another question, wanting to calculate the difference of values over time. Example: I am counting new customers by year and wanting to know absolute and percentage growth.…
- Roland Schlichting
- Director, Corporate Reporting
- Roland_Schlichting
- 2 yrs ago
- 20 replies
- 1,336
- 1
- Alex Zheng8 days ago
- Questions & Answers
- Answered
- Answered
0
Change date format in thoughtspot.
Cant change date format in TSpot. Tried changing via Data>Tables then Column and then changed the date format. But it starts showing date as 03/00/2017.
- Naman Mittal
- BI Developer
- Naman_Mittal
- 2 yrs ago
- 20 replies
- 1,251
- Stuart HerdThoughtSpotter1 yr ago
- Questions & Answers
- Answered
- Answered
0
Formatting a Percent Formula in an Answer
Have the following formula: (sum (transaction) / group_sum (transaction ) ) *100 I need to know the formatting syntax to show the results as a percent with 2 decimal places.…
- Vicki Filaski
- Vicki_Filaski
- 1 yr ago
- 17 replies
- 536
- Marc PriceThoughtSpot All-Star5 mths ago
- Questions & Answers
- Answered
- Answered
0
Open a pinboard by clicking table column value of another pinboard
I would like to open a pinboard by clicking table column value of another pinboard where clicked value should be applied as filter. Ex: I've a summary pinboard which has a table Country and Sales.…
- Sreenivasa Reddy Yelampalli
- Tech Lead
- Sreenivasa_Reddy_Yelampa
- 3 mths ago
- 15 replies
- 55
- Margie RoginskiThoughtSpotter3 mths ago
- Questions & Answers
- Answered
- Answered
0
Script to set permissions
Has anyone got any python script they could share to set permissions on tables for specific groups automatically once they have been loaded via TQL?
- Marc PriceThoughtSpot All-Star
- Business Intelligence Manager - Data & Analytics
- Marc_Price
- 6 mths ago
- 15 replies
- 63
- Tyler SpencerThoughtSpotter4 mths ago
- Questions & Answers
- Answered
- Answered
0
Writing query results to a text file
How can I place results of a tql statement to an output file? For example, I run the following in tql statement: script server; I would like the results placed in a file so I can use "more" or "vi"…
- Greg HackettThoughtSpot Partner
- DBA TS Admin
- Greg_Hackett
- 2 yrs ago
- 15 replies
- 890
- Greg HackettThoughtSpot Partner2 yrs ago
- Questions & Answers
- Answered
- Answered
0
how to load a date field with NULLS via TSLoad
I have a table with a date field... this date field will frequently be NULL. other date fields work fine. but this one, is causing load to fail via TSLoad with the message: Conversion failed,…
- craig vigor
- craig_vigor
- 1 yr ago
- 14 replies
- 209
- Ricardo Da SilvaThoughtSpotter6 mths ago
- Questions & Answers
- Answered
- Answered
0
tsload enclosing character error
i tried to load my data (using tsload) from csv into thoughtspot but keep failing due to enclosing character error. anyone can help me, please?
- Haikal
- Haikal
- 9 mths ago
- 14 replies
- 181
- Haikal9 mths ago
- Questions & Answers
- Answered
- Answered
0
How to change join type
Hi guys, How can I change joining type under schema? I would like to have outer join. Thank you.
- Haikal
- Haikal
- 9 mths ago
- 14 replies
- 112
- Rajiv MaskaraThoughtSpotter9 mths ago
- Questions & Answers
- Answered
- Answered
1
Month to date growth
Is there a way to get growth for the month to the current date? For example to compare August 1st to August 21st for 2016 to 2017? I have several people wanting to check what their growth is so far…
- Steven Bohlson
- Steven_Bohlson
- 2 yrs ago
- 14 replies
- 1,511
- 1
- Roland Schlichting2 yrs ago
- Questions & Answers
- Answered
- Answered
1
Worksheet dimensions switch : mass update script ?
hi, We do need to implement a change at worksheet switching from a calculated dimension (at WS level) to another dimension from fact. Basically the initial calulation at WS level has been pushed at…
- pa
- BI dev
- pa_chanteau
- 3 mths ago
- 13 replies
- 65
- 1
- pa1 mth ago
- Questions & Answers
- Answered
- Answered
0
Slowly Changing Dimensions
Thoughtspot with slowly changing dimensions. In the data loading module, in the presentation video at about minute 44 of bootcamp, the presenter is talking about slowly changing dimensions, ie,…
- Robert Lepine
- Trainer
- Robert_Lepine
- 3 mths ago
- 12 replies
- 77
- Damian WaldronThoughtSpotter3 mths ago
- Questions & Answers
- Answered
- Answered
0
export users to excel
I have used the python tsAPI to export/print our TS user accounts. However, that API does not allow me access to the email field for the user accounts.…
- Michael Dockery
- I love data, electronics, wood working and puppies
- Michael_Dockery
- 9 mths ago
- 12 replies
- 94
- Bill BackThoughtSpotter7 mths ago
- Questions & Answers
- Answered
- Answered
0
Ask feature of Geo Bubble visualization
Hi all, I try to visualize our data using geo bubble, please help to: I want to display the size of bubble is reflect to value of the unit / amount, so the size will became bigger if quantity of…
- Sriyono Basuki
- BI Team Lead
- SriyonoBasuki
- 1 yr ago
- 12 replies
- 71
- Rajiv MaskaraThoughtSpotter11 mths ago
- Questions & Answers
- Answered
- Answered
0
Data loading from csv to TS using TQL
Hi , Can anyone please give the example of how to load the data from cvs to TS using TQL commads
- Sreekanth Upputuri
- Sreekanth_Upputuri
- 1 yr ago
- 12 replies
- 249
- Sreekanth Upputuri1 yr ago
- Questions & Answers
- Answered
- Answered
0
Month to Date excluding Todays value
I am trying to write a formula or query that will generate the month to date profit WITHOUT todays profit being included. Afterwards, I'll want to device the resulting value by todays date MINUS…
- Connor
- Connor
- 1 yr ago
- 12 replies
- 351
- Connor1 yr ago
- Questions & Answers
- Answered
- Answered
0
Datetime Format for Table with 3 letter month and spaces
What is the correct Datetime format for this value "Jan 3 2020 11:00am". I tried to enter in "MMM d YYYY h:mma" but it wont take this. What is the correct Format Pattern for this type of datetime?
- Tenchy Jefferson
- BI Lead Developer
- Tenchy_Jefferson
- 4 mths ago
- 11 replies
- 22
- James BelseyThoughtSpotter4 mths ago
- Questions & Answers
- Answered
- Answered
0
SSL Certificate for MacOS
Hi, When configuring SSL certificates; is there any exception for MacOS? We have a client where we have successfully configured the SSL certificates, however, I have just picked up that one Mac user,…
- Monique
- Training Manager
- Monique
- 9 mths ago
- 11 replies
- 35
- Marc PriceThoughtSpot All-Star6 mths ago
- Questions & Answers
- Answered
- Answered
1
Formula based on production date
Hello I am trying to create a line graph showing # of transactions in a given day. The formula I have so far is: sum(group_unique_count(id)). This works only when I want to filter my time set to one…
- Hamza Alsalman
- Business Intelligence
- Hamza_Alsalman
- 1 yr ago
- 11 replies
- 316
- 1
- Hamza Alsalman1 yr ago
- Questions & Answers
- Answered
- Answered
0
Add hours function
Is there a function to add hours to datetime value? For example I want to add hours to current date time. For example 7/18/2017 00:00 --> add 5 hours -->7/18/2017 05:00
- Steph Fisher
- Steph_Fisher
- 2 yrs ago
- 11 replies
- 793
- Snigdha JhaThoughtSpotter2 yrs ago
- Questions & Answers
- Answered
- Answered
0
Filtering Formula Results
I am looking to filter boolean formula results to equal "true" within a table I have created, however when I click on the filter option it loads indefinitely and I cannot choose my criterium.…
- Tyler Rowley
- Accounting Manager
- Tyler_Rowley
- 3 mths ago
- 10 replies
- 29
- PaolaThoughtSpotter3 mths ago
- Questions & Answers
- Answered
- Answered

1 2 3 4 5 31 Next

Back to top

Have a question? Ask it here. Or reply and share your knowledge.

HELPFUL LINKS

COMMUNITY GUIDELINES

MEET A PRO (OFFICE HOURS)

PRODUCT DOCUMENTATION

THOUGHTSPOT USER GROUP EVENTS

THOUGHTSPOT U (TRAINING & CERTIFICATION)

GITHUB COMMUNITY TOOLS

RELEASE HIGHLIGHTS

Categories

View all topics

Tags

Top contributors

View all members

Recent activity