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,452
- 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,078
- 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
- 898
- Monique10 mths 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
- 8 mths ago
- 23 replies
- 116
- Ashley Mueller10 days ago
- Questions & Answers
- Answered
- Answered
- Margie RoginskiSpotter
- Senior Manager, Product Management
- Margie_Roginski
- 3 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,118
- 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,195
- 1
- Victoria Bialas10 mths 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
- 400
- Marc PriceThoughtSpot All-Star2 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
- 842
- 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
- 10 mths ago
- 14 replies
- 149
- Ricardo Da SilvaSpotter1 mth 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
- 4 mths ago
- 14 replies
- 70
- Haikal4 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
- 4 mths ago
- 14 replies
- 38
- Rajiv MaskaraSpotter4 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,342
- 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
- 3 mths ago
- 12 replies
- 59
- Bill BackSpotter1 mth 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
- 9 mths ago
- 12 replies
- 62
- Rajiv MaskaraSpotter5 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
- 8 mths ago
- 12 replies
- 156
- Sreekanth Upputuri8 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
- 323
- Connor1 yr 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
- 3 mths ago
- 11 replies
- 32
- Marc PriceThoughtSpot All-Star3 wk 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
- 773
- Snigdha JhaSpotter2 yrs 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
- 939
- 1
- Chandan PaulThoughtSpot All-Star1 mth 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
- 442
- Curtis BalusekThoughtSpot Partner4 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
- 5 mths ago
- 10 replies
- 61
- Ervin De Guzman5 mths ago
- Questions & Answers
- Answered
- Answered
0
Time Format
I have a datetime field I am using with the hour_of_day function. I would expect to see 12PM, 1PM, etc. but what I see is 12/31/1899 12PM, 12/31/1899 1PM. I want just the time/hour.…
- Paul Dailey
- Data Analyst
- Paul_Dailey
- 1 yr ago
- 10 replies
- 239
- Paul Dailey9 mths ago
- Questions & Answers
- Answered
- Answered
1
How Should County Data Be Expressed for Geo Visualizations
How does ThoughtSpot recognize county data? In what format does ThoughtSpot need the data to accurately express the county data in a geographic visualization?
- Phillip Hetzel
- Phillip_Hetzel
- 1 yr ago
- 10 replies
- 234
- 1
- Michael ArmentanoSpotter10 mths ago
- Questions & Answers
- Answered
- Answered
0
Stacked Bar
Hi All - I'm trying to create a stacked bar, but only getting options to create normal bars. Is there a way I can aggregate my data so that it stacks on an axis? I attached 2 images.…
- Morgan Strong
- Morgan_Strong
- 1 yr ago
- 10 replies
- 342
- Divya10 mths ago
- Questions & Answers
- Answered
- Answered

1 2 3 4 5 26 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