Okay
  Public Ticket #1270490
How to create a chart based on column totals
Closed

Comments

  • jmanfred started the conversation

    I need help creating a graph (donut style - I don't care if it is google, highgraph, or js) that compares the totals for the columns New Access Points and Removed Access Points. The table's filter is working properly (yay) but I cannot find the totals column for these two fields (I tired range and grouping). Please help. This is the last piece to my project, which of course is due tomorrow. Thank you!

  • [deleted] replied

    Hi jmanfred,


    You need to create formula column in which you will be able to calculate totals. You can do it by following this tutorial.

    After that you just need to include that column in your graph.  

  • jmanfred replied

    I've watch the tutorial a couple of times... can you tell me what I need to put in the formula are to add up or the sum of all the rows in the column? 

    Also, another question I had was if I duplicated a table and want to use the same data, but hide columns to display different views, will that also adjust the original table or is just the data linked?

    Thanks for the help!

    Jennifer

  •   jmanfred replied privately
  • [deleted] replied

    Hi Jennifer,

    Sorry for misunderstanding. I understood that you want to calculate values between two columns and not all the values from one column.

    • can you tell me what I need to put in the formula are to add up or the sum of all the rows in the column? 

    At this point we do not have option to show totals from both columns in the chart. You can show it below the table but not in charts. 

    • if I duplicated a table and want to use the same data, but hide columns to display different views, will that also adjust the original table or is just the data linked?

    Duplicate functionality is designed for that purpose, so you can show same data in different ways. If you duplicate the table and save it with different settings it will act like a different table with same data source. If you try to duplicate  manually created table you will have an option to duplicate data as well so you will have completely separate table in which you can change the data also without changing it in original table

    • I also need help with linking tables. For example in the screenshot called primary view, the table at the bottom called individual predictions needs to have each row be a URL that links to a modal pop up that provides detailed info for that row (like the screenshot modal view).

    We do not have this option built in. It was requested already and we have plans to built it but we do not have timestamp on it. You will need to create custom solution to make it work.