Available keywords for Charts views

Follow

Comments

25 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

     

     

     

     

    0
    Comment actions Permalink
  • 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

    0
    Comment actions Permalink
  • 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?

     

    0
    Comment actions Permalink
  • 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

    0
    Comment actions Permalink
  • 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???

    0
    Comment actions Permalink
  • Avatar
    Awesome Table

    Hello Krista,

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

    Regards,

    Nicolas

    0
    Comment actions Permalink
  • 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. 

    0
    Comment actions Permalink
  • 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

    0
    Comment actions Permalink
  • 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?

     

    0
    Comment actions Permalink
  • 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

    0
    Comment actions Permalink
  • Avatar
    Madison González

    Hola!

    Me gustaria saber como puedo copiar o descargar los gráficos generados de forma individual, ya sea como imagen o como elemento gráfico editable?

    0
    Comment actions Permalink
  • Avatar
    Randolph Abelardo (Edited )

    Hi @Madison. 

    There's currently only 1 option: to download the entire Advanced Summary view as a flat (uneditable) PDF. More about this here.
    If you want editable charts, you can simply add charts on your datasource's blank space (or separate sheet) and create the same charts by using this detailed steps.

    You can also create a Feature Request for the ability to download individual graphs as images.

    Hope this helps. 

    - Randy

    0
    Comment actions Permalink
  • Avatar
    Stat NSIS-NAMD

    Hello, is there a bug regarding the BIAggregate? It seems it's not functioning correctly lately. Thank you. 

    1
    Comment actions Permalink
  • Avatar
    Randolph Abelardo (Edited )

    Thanks for reporting this, Stat NSIS-NAMD.
    I'll forward this to our Dev Team and create a ticket so you can track the status.

    - Randy

    0
    Comment actions Permalink
  • Avatar
    Pete Schoen

    Hello, similarly my BIAggregate chart is not functioning like it originally intended. I would like it to create a SUM of all the numbers in the column but its showing me several numbers (possibly sums) with no reference to what the numbers connect to. 

    Thanks. 

    0
    Comment actions Permalink
  • Avatar
    Andrew Carrier

    How do I go about turning one of these functions off? In my Awesome Table, it keeps turning my free form answers into word clouds. This doesn't provide me with anything and I'd like the full answers to be left as is. Furthermore, when I update the filters, it'll change some from being strings to word clouds.

    0
    Comment actions Permalink
  • Avatar
    Randolph Abelardo

    Hi Andrew Carrier.

    Awesome Table automatically chooses the best-fitted chart depending on the type of data for each column. But you can force the display of another chart with your preferred Advanced Summary keyword.

    However when you force the display with one of these keywords, you need to check the column type of your data in your spreadsheet because some of these keywords are specific for numbers and others are specific for text.

    - Randy

    1
    Comment actions Permalink
  • Avatar
    Andrew Carrier

    Randolph Abelardo Thank you. I have a follow-up question, I would like to show the my data using BIResult using comma separated strings (i.e. Morning, Mid-Morning, Mid-day...). I know I can use the csvFilter with BIResult and it shows fine, however I don't want that filter at the top. 

    Basically what I'm asking is, can I show information using BiResult - csvFilter , without the actual filter being available?

    0
    Comment actions Permalink
  • Avatar
    Randolph Abelardo (Edited )

    Hi Andrew Carrier.

    ... can I show information using BiResult - csvFilter , without the actual filter being available?

    This isn't possible. A dropdown menu is automatically added when we use a csvFilter. To remove the dropdown menu, you will need to remove the csvFilter keyword from the relevant column.

    To clarify: you don't need to use the csvFilter keyword for your comma-separated entries if you just need to present or display these in your view. The csvFilter should only be used if there's a need to filter the options.

    Hope this helps.

    - Randy

    0
    Comment actions Permalink
  • Avatar
    Andrew Carrier (Edited )

    Randolph Abelardo How do I go about presenting comma-separated entries without the filter? When I remove csvFilter, it presents that column as individual strings in Awesome Table. To be clear - the values are not single words and the respondents could enter their own string (in addition to selecting from the list).

    Furthermore, I've noticed on BIPie the percentages are wrong when using csvFilter. I have 280 total responses, 211 have selected an answer, but it gives 37% in my pie chart. This is in relation to the same form question mentioned above.

    0
    Comment actions Permalink
  • Avatar
    Randolph Abelardo

    Hi Andrew Carrier.

    I will open a support-ticket for this case so we can troubleshoot it faster.

    - Randy

    0
    Comment actions Permalink
  • Avatar
    Andrew Carrier

    Hi Randolph Abelardo, thank you for your help. The BIPie percentages aren't wrong, I just realized that they use the the total number of entries as opposed to the number of respondents to calculate the percentages. 

     

    However, if you can help with presenting comma-separated entries without the filter, that would be very helpful.

    0
    Comment actions Permalink
  • Avatar
    Randolph Abelardo

    Hi Andrew Carrier.

    Please share your:

    AwesomeTable link - Share with us your AwesomeTable & Google Sheets datasource so we can pinpoint where the problem is and provide the right solution at the soonest possible time. Detailed instructions here.

    Google Sheets datasource - It's best to set the sharing settings to Anyone with the link. Click here to learn more.


    - Randy

    0
    Comment actions Permalink
  • Avatar
    Kaitlyn Sanford

    When using BiColumnChart, I'm noticing that the averages are scewed when "Not Applicable" is entered into the form. However, not all the time, just sometimes. Below is when a student had "Not Applicable" entered as the score and it worked:

    Here is an example of how it shows up when it doesn't work:

    In the broken example, the student only had one entry of "Not Applicable" and this is how it shows up. 

     

    Any suggestions?

    0
    Comment actions Permalink
  • Avatar
    Awesome Table

    Hi Kaitlyn Sanford

     

    Could you please create a ticket to raise your issue on our contact form here: https://support.awesome-table.com/hc/en-us/requests/new

    Please be sure to share your spreadsheet and view with our support team (support@awesome-table.com

    Best regards

    0
    Comment actions Permalink

Please sign in to leave a comment.