Currently the gadget (Issue Statistics) for my Finance Ops dashboard shows 'Number of Tickets' & 'Total of Tickets in percentage' by stages (Under Assessment/New/Reviewed/In Progress/Closed).
What I want is, to show 'Total Invoice Amount' for each stages (Under Assessment/New/Reviewed/In Progress/Closed) rather than 'Number of Tickets'. Could it be done? If so, how?
It should be like this...
Example:-
Under Assessment 1 (Number of Tickets) $100.50 (Total of 1 Invoice) 0%
New 3 (Number of Tickets) $600.00 (Total of 3 Invoices) 1%
Reviewed 3 (Number of Tickets) $1000.95 (Total of 3 Invoices) 1%
In Progress 3 (Number of Tickets) $400.20 (Total of 3 Invoices) 1%
Closed 209 (Number of Tickets) $30525.05 (Total of 209 Invoices) 95%
Total Issues: 219 (Number of Tickets) $32626.70 (Total of 219 Invoices)
Urgently need to solve this matter.
Thank you in advance.
Camelia
Considering that you have to aggregate, usually calc field can't help you
You can try with different solutions.
Custom plugin to sum:
Custom Plugin to make some aggregation or BI
Oh. So, that means I have to use the solutions that you had provided?
Is there any other plugins that are FREE and have the same function?
Will test it out the solutions you had stated for now by using their free trial.
Will be back if there's any problem regarding this.
Thank you very much Sir. Appreciate it.
Camelia
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.