- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 23, 2023 04:04 PM
Hello,
Is it possible to combine multiples of identical x-axis values in the interface chart?
I have multiples of identical x-axis values and I want to combine those values into 1 bar.
I could make a special summary table with a roll-up but then the person using the interface would not be able to filter the records the way they want, so I need the chart to show all the records and be connected to the accessible filter element in the interface.
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 24, 2023 04:57 PM
What type of field is your x-axis?
I would recommend using a "Single Select" field type. From there, do a bit of data management to match all the identical fields.
Justin Ng
Programme Coordinator at Sistema Aotearoa
https://www.sistemaaotearoa.org.nz/

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 24, 2023 04:57 PM
What type of field is your x-axis?
I would recommend using a "Single Select" field type. From there, do a bit of data management to match all the identical fields.
Justin Ng
Programme Coordinator at Sistema Aotearoa
https://www.sistemaaotearoa.org.nz/
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 25, 2023 08:38 AM
Hi @Sistema_Aotearo ,
I actually ended up using a linked field instead of a single select, but your strategy worked perfectly thank you!
