As previously announced via banners and our newsletters, support is no longer available through this platform.

For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.

You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.

Paid customers: Please log in to your store account for support.

Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com

Okay
  Public Ticket #2816340
Counting Items
Closed

Comments

  • Andrew Kennedy started the conversation

    Hello!

    I'm trying to replicate the chart below, but cannot find anything about this in the help section. I need to create a chart showing the number of items in a certain category, and ideally the sub-group categories.

  • Andrew Kennedy replied

    Just to follow up - I had a developer help me write an SQL query to count the number of courses in a particular category and add that to a new table. Is this the way to go if WPDataTables cannot calculate sums of non-integers?

  •  2,576
    Aleksandar replied

    Hello Andrew 

    Thank you for your purchase, and sorry for the late response.

    wpDataCharts accepts only one string-type column (string, date, datetime, URL, or email link) so this second table that you've shown us looks alright.

    I haven't tried creating a stacked column chart with this data, but it looks like you should have no issues here.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia 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

  • Andrew Kennedy replied

    Thank you - this is helpful. The last thing I need is to figure out if a date view like in the attached is possible? There doesn't seem to be a chart that handles dates this way (yes, I know it is unfair to compare to Tableau!)

  • [deleted] replied

    Hi Andrew

    The only chart types we have available are displayed in our charts library. Unfortunately we don't have the chart type from your screenshot, but I will kindly ask you to leave your suggestion following this link and our developers will consider it for one of our future updates.