Is there an easy way to invert a table from linked data?
I'm having trouble turning my data into a pie chart, which allows only two columns. My data looks kind of like this:
Label Total Active Inactive
Podcasts 505939 5034 50700
wpDataTables will let me select only two columns, and the first must be a string. So is there a way to maintain the data link to my JSON file and invert this data so it looks like the following?
Label Podcasts
Total 505939
Active 5034
Inactive 50700
I would need to do such inversion from wpDataTables while maintaining the link, so I can easily get the latest data from the data source.
Looks like you need to pivot the table, and unfortunately something like this is not possible with wpDataTables.
What I usually recommend for this would be to perform the PIVOT of the table in the database, but since you're linking to a JSON file, this wouldn't work for you. So, you would need to prepare a PHP adapter which would transform the data to the table that you need.
Is there an easy way to invert a table from linked data?
I'm having trouble turning my data into a pie chart, which allows only two columns. My data looks kind of like this:
Label Total Active Inactive
Podcasts 505939 5034 50700
wpDataTables will let me select only two columns, and the first must be a string. So is there a way to maintain the data link to my JSON file and invert this data so it looks like the following?
Label Podcasts
Total 505939
Active 5034
Inactive 50700
I would need to do such inversion from wpDataTables while maintaining the link, so I can easily get the latest data from the data source.
Thanks in advance!
Hi again Daniel.
Looks like you need to pivot the table, and unfortunately something like this is not possible with wpDataTables.
What I usually recommend for this would be to perform the PIVOT of the table in the database, but since you're linking to a JSON file, this wouldn't work for you. So, you would need to prepare a PHP adapter which would transform the data to the table that you need.
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