Available keywords for Advanced Summary views

Follow

Comments

10 comments

  • Avatar
    Gustavo A. Valero P.

    Hi,

    Something is wrong with the column name called "Results" associated to BICount keyword.

    When the web page (report) is loaded at beginning everything works fine, BICount put "MyColunmName" and "Results" as headers of my table correctly but if the user will change any parameter by using any filter, the "Results" name dissapears and is replaced with "MyColunmName" value again. 

    In your live example you can see this problem, the "What is your nationality?" and "Results" headers appear fine at the begining but if you will change the date (using Timestamp), the "Results" header disappears and you will see twice "What is your nationality?" in both headers!

    I hope and know you will fix this litlle detail.

    Have a great day friends!

    Saludos

    Gavp

     

     

     

     

  • Avatar
    Thomas Morin

    Hello Gustavo A. Valero P.,

    Indeed, it is a bug that we will solve as soon as possible.
    We thank you a lot for warning us.

    *We will let you know when this issue will be fixed.

    Kind regards.

    Thomas

  • Avatar
    Stian Ihasee

    It seems like google stores multiple choice answers in the format of: "choice1, choice2, choice3" in each cell. When this information is presented in the standard google forms charts each choice (choice1, choice2 etc.) is being handled as a single value. When I display the information with a keyword like "BICount" in advanced summary the cell with choices: "choice1, choice2, choice3" is displayed as a single value. Am I doing something wrong here?

     

    Here is an example:

    In the 4th row the values "Dyre and "Kjedelige" are treated as one value.
    Is there anything I can do to fix this?

     

  • Avatar
    Thomas Morin

    Hello,

    It is a normally behavior. When your question is a multiple choice in your GForm, only one response can be sent. In this case, our keywords will handle your values as a single value.

    Kind regards.

    Thomas

  • Avatar
    Krista Delaney

    I am trying to look at the data for a particular short answer question.  There are many possible "right" answers, so what I am hoping to see is a pie chart that simply shows how many earned the point vs how many did not.  I do not want to see each answer represented by itself.  Is this possible???

  • Avatar
    Awesome Table

    Hello Krista,

    There are unfortunately no built-in functionalities to achieve this.

    Regards,

    Nicolas

  • Avatar
    Pete Schoen

    Hi, I'm trying to take a bunch of google form results and make them into a Data Analytics chart through Awesometable. Right now what I see on the chart based on this code is a Pie Chart that counts every time someone inputs a "Main reason for contact" and gives the percentage of times each reason is inputted. Then I see a sum of the minutes when I csvfilter by "Main reason for contact".

     

    What I would realllly like to do, is create a Pie chart that uses the "Main reason for contact" as the subject but then make the percentage of time based on the "How much time did you spend" column. So the 1 on 1 Instructional Feedback in the first row would be matched with the 40 minutes and those two pieces of info would come together to make a pie chart. Is it possible to create a chart that meshes two columns? Thanks for the help. 

  • Avatar
    Thomas Morin

    Hello Pete,

    It is not possible to achieve your request with Awesome Table. This view only allows you to display data from one column. You can't mix two columns in one chart.

    Thank you for your understanding.

    Thomas

  • Avatar
    M. Pilar Valverde

    Hello,

    In Google Sheets have column where the values can be numbers or numbers preceded by a Japanese character, like this:

    Título de inglés: EIKEN
    StringFilter - BICount
     
    準1
     
    2
     
    準1
    2
    準2
    2
    2
    2

    However, when I view the table with Awesome table, I can see the numbers but not the numbers preceded by a Japanese character.

    I tried assigning the CategoryFilter and the StringFilter type but the result is the same. Is it possible to solve this?

     

  • Avatar
    Thomas Morin

    Hello M. Pilar Valverde,

    It seems the Japanese character is text format and it is not possible to mix numbers and text with the stringFilter.

    Thank you for your understanding.

    Thomas

Please sign in to leave a comment.