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,475
- 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,097
- 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
- 901
- 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
- 9 mths ago
- 23 replies
- 126
- Ashley Mueller2 mths ago
- Questions & Answers
- Answered
- Answered
- Margie RoginskiSpotter
- Senior Manager, Product Management
- Margie_Roginski
- 5 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,…
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,142
- Stuart HerdSpotter1 yr ago
- Questions & Answers
- Answered
- Answered
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
- 19 replies
- 1,223
- 1
- Victoria Bialas1 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
- 435
- Marc PriceThoughtSpot All-Star1 mth 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
- 2 mths ago
- 15 replies
- 55
- Tyler SpencerSpotter12 days 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
- 1 yr ago
- 15 replies
- 852
- Greg HackettThoughtSpot Partner1 yr 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
- 159
- Ricardo Da SilvaSpotter2 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
- 5 mths ago
- 14 replies
- 94
- Haikal5 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
- 5 mths ago
- 14 replies
- 55
- Rajiv MaskaraSpotter5 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,364
- 1
- Roland Schlichting2 yrs 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
- 5 mths ago
- 12 replies
- 66
- Bill BackSpotter3 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
- 11 mths ago
- 12 replies
- 64
- Rajiv MaskaraSpotter6 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
- 10 mths ago
- 12 replies
- 168
- Sreekanth Upputuri10 mths 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
- 328
- 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
- 12 days ago
- 11 replies
- 13
- James BelseySpotter12 days 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
- 5 mths ago
- 11 replies
- 32
- Marc PriceThoughtSpot All-Star2 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
- 312
- 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
- 776
- Snigdha JhaSpotter2 yrs ago
- Questions & Answers
- Answered
- Answered
1
Nested Aggregation - Percentage compared to Max aggregated value
Hi community, I'm stuck with (maybe) a simple calculus regarding flexible aggregation functions. For each category, I need to calculate the percentage compared to the max values (both aggregated).…
- Fabio Fantoni
- Modern BI & Analytcs Team Leader
- Fabio_Fantoni
- 2 mths ago
- 10 replies
- 38
- 1
- Fabio Fantoni1 mth ago
- Questions & Answers
- Answered
- Answered
1
Not counting nulls in unique count
I want to create a formula that counts all of the unique values except for the null. Is there a good way to do this?
- Bill BackSpotter
- Customer Success Architect
- Bill_Back
- 2 yrs ago
- 10 replies
- 952
- 1
- Chandan PaulThoughtSpot All-Star3 mths ago
- Questions & Answers
- Answered
- Answered
0
How do you model multiple column relations to the same dimension table?
I have a fact table with 3 different "Associate ID" columns for different purpose and I want each of them to join to my associate master dimension table so that their name, job code,…
- Greg Brown
- Lead Data Warehouse Analyst
- Greg_Brown
- 1 yr ago
- 10 replies
- 459
- Curtis BalusekThoughtSpot Partner6 mths ago
- Questions & Answers
- Answered
- Answered
0
Loading of Timestamp data
Hi ThoughtSpot Users, I would like to load timestamp data to the thoughtspot db. But im getting error on tsload: ;Reason: Conversion failed, error=Can not convert " 2010-01-29 13:40:…
- Ervin De Guzman
- Ervin_De_Guzman
- 6 mths ago
- 10 replies
- 74
- Ervin De Guzman6 mths ago
- Questions & Answers
- Answered
- Answered

1 2 3 4 5 27 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 U (TRAINING & CERTIFICATION)

GITHUB COMMUNITY TOOLS

RELEASE HIGHLIGHTS

Categories

View all topics

Tags

Top contributors

View all members

Recent activity