ThoughtSpot Website
Sign Up
Login
ThoughtSpot Community ThoughtSpot Community
What are you looking for?
HomeCommunity

Questions & Answers

All topics
  • Community
    • Questions & Answers
    • Discussions
    • Announcements
    • ThoughtSpot Events
  • Using ThoughtSpot
    • Getting Started
    • Latest Features
  • SpotLight
    • Beyond 2019
    • Industry Knowledge
Have a question? Ask it here. Or reply and share your knowledge.
  • Filter
  • Active
  • Newest
  • Most replies
    • Clear sort
    • Most likes
    • Most replies
    • Most views
  • Status
    • Clear sort
    • Answered
    • Unanswered
  • Tags
    • Clear filter
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

BEYOND.2019 

BEYOND.2018

Categories

  • Community
    • Questions & Answers
    • Discussions
    • Announcements
    • ThoughtSpot Events
  • Using ThoughtSpot
    • Getting Started
    • Latest Features
  • SpotLight
    • Beyond 2019
    • Industry Knowledge
View all topics

Tags

View all tags

Top Contributors

View all members

Recent Activity

Powered by Forumbee

Home

  • Community
    • Questions & Answers
    • Discussions
    • Announcements
    • ThoughtSpot Events
  • Using ThoughtSpot
    • Getting Started
    • Latest Features
  • SpotLight
    • Beyond 2019
    • Industry Knowledge
View all topics

Tags

View all tags

HELPFUL LINKS

COMMUNITY GUIDELINES

MEET A PRO (OFFICE HOURS)

PRODUCT DOCUMENTATION

THOUGHTSPOT U (TRAINING & CERTIFICATION)

GITHUB COMMUNITY TOOLS

RELEASE HIGHLIGHTS

BEYOND.2019 

BEYOND.2018

ThoughtSpot Website