i created an Invoice (CustomPostType) with fields, like Invoice Positions. I love to create now a Pie Chart, with Amount of open Invoices and paid Invoices.
But without a Amount Filed. Because i do calculate the total Amount every time i create a PDF Invoice.
So i think i have to deserialize those Fields somehow.
Maybe with a Formula Column?
I'm now also trying to filter alle for just to see "invoice"-type.
Do you have any Manual about this. So i know how to do this?
To create charts, you need integer or float columns, while only one string-type column should be used for axis labels
I see that your table contains a lot of serialized data, and you need to unserialize that before you can put it to use.
I cannot tell you how to do that since that can be achieved with customization, and custom queries. Those queries can be run in the database, by creating a view; or from within the plugin. If you go for the view, you need to create a view, and in the plugin's UI create a new SQL query based table with
SELECT * FROM viewName
This is all custom, and unfortunately I can't help you with it. Please take a look at charts on our documentation and sandbox sites, and see how they look like. You can also try prepairing a manual table with simple values to verify the charts do actually work.
Dear Support
i created an Invoice (CustomPostType) with fields, like Invoice Positions. I love to create now a Pie Chart, with Amount of open Invoices and paid Invoices.
But without a Amount Filed. Because i do calculate the total Amount every time i create a PDF Invoice.
So i think i have to deserialize those Fields somehow.
Maybe with a Formula Column?
I'm now also trying to filter alle for just to see "invoice"-type.
Do you have any Manual about this. So i know how to do this?
Thanx a lot in adv.
Reinhard
I also can not create a Donat-Chart :-(
Hello Reinhard
To create charts, you need integer or float columns, while only one string-type column should be used for axis labels
I see that your table contains a lot of serialized data, and you need to unserialize that before you can put it to use.
I cannot tell you how to do that since that can be achieved with customization, and custom queries. Those queries can be run in the database, by creating a view; or from within the plugin. If you go for the view, you need to create a view, and in the plugin's UI create a new SQL query based table with
SELECT * FROM viewName
This is all custom, and unfortunately I can't help you with it. Please take a look at charts on our documentation and sandbox sites, and see how they look like. You can also try prepairing a manual table with simple values to verify the charts do actually work.
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