Forum Discussion
Grouped amount based on average payment speed
Hi,
I have two different tables, Relations and Invoices
Now I have calculated the datediff between the invoice date and the payment date.
I have created a table with the average payment speed of every relation.
I also have created a group that I need for another calculation
Now I want to create a diagram where it shows me the amount of relations in each group.
I cannot use a new calculated column because then the average does not look at slicers.
I did try to make a column based on the average and IF function to make the group.
Hope it makes a bit of sense.
Kind regards,
Tim Wijnen
7 Replies
Just use betaalsnelheid as both 'categorie' (category) and 'waarde' (amount) in a bar chart. Under waarde select 'Aantal' (Count) and that should be ready. It'll show you the different groups and the amount of firms per group.
Mark this as solved if it helped you, if it didn't let me know too and I'll try and help.
Veel succes!
That doesn't work because that will give me the amount based on every invoice, not on the calculated average of the client.
In a bar charter you only have Ax/Legenda/Amount/Tooltips.
I have deleted the groups because that doesn't work the way I want.
I now have created a measure wich shows me the right value in table.
But I haven't been able to make a bar chart where I can see the amount of each group.
I do have a similar problem with a treemap. The treemap shows the top 10 of slowest and fastest paying clients, but now I want to add that I only want to see clients over a certain value. I can't put a filter to the invoice amount because that looks at single values.
