Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Table Charts and Filter -Chart from Table for Multiple Entries

I am trying to configure a chart to to display an entry count

This works fine when i have a single entry per field, but not when I have multiple values per field.

In the example below I would expect to see 3 entries in the PIE chart, with the following values

Adhoc Payee = 4

Direct Debit = 1

Standing Order = 1

mult entries.PNG

However what I actually get is 2 entries

Adhoc Payee = 3

Adhoc Payee, Direct Debit, Standing Order = 1

I have managed to get this working for the Filter macro (showing only single entries) by using the a drop down filter and setting the cell value delimiter for it to an apostrophe. However cannot seem to get the same thing working for the chart side

1 answer

1 accepted

3 votes
Answer accepted
Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Oct 20, 2023

Hi @Craig.Harley ,

Please use the Pivot Table macro before the Chart from Table macro: visit the Options tab and set the Cell value delimiter as "," for the example from your screenshot.

Then you'll be able to count your entries correctly and your chart will be created using this aggregated table.

Thank you , that worked perfectly, just starting to get up to speed with how this macro works

Like Stiltsoft support likes this

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events