I have a spreadsheet with a column for Acrobat version. There are 63 rows and the Acrobat column has the version in the cell. In the screenshot i attached to this support case, the version lists on the left, but what is the numbering on the bottom (running horizontal)? I'd like the numbering to reflect how many rows contain a particular version of Acrobat.
So in my screenshot, that mouse-over display showing the Acrobat version 19.010.20091, the 853 should be the number of rows that contain 19.010.20091 in the Acrobat column.
If I understood you correctly, you want the chart to display the number of instances where 19.010.20091 appears, correct?
If that is true, you need to add an integer column which will always have a pre-defined value of "1", so each instance of any entry will be recorded as a single input.
Then, when you create a chart, you can enable grouping, so all "19.010.20091" will be grouped and the integer column will be summed to the number of instances it appears in.
You can hide that column from view, and still use it in a chart.
I have a spreadsheet with a column for Acrobat version. There are 63 rows and the Acrobat column has the version in the cell. In the screenshot i attached to this support case, the version lists on the left, but what is the numbering on the bottom (running horizontal)? I'd like the numbering to reflect how many rows contain a particular version of Acrobat.
So in my screenshot, that mouse-over display showing the Acrobat version 19.010.20091, the 853 should be the number of rows that contain 19.010.20091 in the Acrobat column.
How can i accomplish this?
Hello homemadebyx.
If I understood you correctly, you want the chart to display the number of instances where 19.010.20091 appears, correct?
If that is true, you need to add an integer column which will always have a pre-defined value of "1", so each instance of any entry will be recorded as a single input.
Then, when you create a chart, you can enable grouping, so all "19.010.20091" will be grouped and the integer column will be summed to the number of instances it appears in.
You can hide that column from view, and still use it in a chart.
I hope this helps.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
I tried to post a reply to you after you replied, but replying wasn't working. You solution worked great for me. Thank you
Hello again homemadebyx.
Yeah, Ticksy didn't update their certificate, so no one was able to post anything.
You are welcome. Glad that we solved the issue.
If you have any more issues or questions feel free to open a new ticket, we will gladly help.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables