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,572
    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.