Holiday Notice – Support Unavailable on April 18 and April 21

We just wanted to let you know that our support team will be offline on Friday, April 18th (Good Friday) and Monday, April 21st (Easter Monday) due to the holidays.
We'll be back on Tuesday, ready to assist you!

In the meantime, if you need any help, feel free to:

Amelia YouTube Channel

wpDataTables YouTube Channel

Thank you for your understanding, and we wish you a wonderful holiday weekend!

Okay
  Public Ticket #1348609
Formula to count string
Closed

Comments

  • accounts_introtime started the conversation
    October 26, 2017 at 7:46pm

    Hi,

    I was wondering if there is a way I can count number of times string is in column.  I am trying mimic the same excel formula  =COUNTIF (range, criteria)

    I have a file that will constantly change, and I want to create a gauge chart based on the information from this.  However the challenge is this file contains many columns and I want to display the number of times a particular keyword is used in a certain column.  For example below is column I want number of times live is used in this column.  In excel I can do this by =COUNTIF formula how do I do this in wpdatatables. How do I do countif function in wpdatatables

    Status:

    Live

    Dead

    Live 

    Dead

    Live

    Live

  •  472
    Isidora replied
    October 27, 2017 at 6:19am

    Hi accounts_introtime,
    Thank you for your purchase.

    Unfortunately this is not possible with built in features of plugin.

    Kind Regards, 

    Isidora Markovic

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

    Amelia: FAQ | Facebook | Twitter |  Amelia demo sites | Docs

    You can try our wpDataTables add-ons before purchase on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables

  • accounts_introtime replied
    October 27, 2017 at 3:24pm

    Hi,

    As per your response it's not possible with built-in features.  What about customization.  I am trying to build a similar site like https://www.klipfolio.com/ for a client.  If there are any addons that we can purchase or use to achieve similar functionality please let me know.  If not, than I just wasted $50 on a plugin that is no use to us.

    Thanks

  •  472
    Isidora replied
    October 29, 2017 at 8:58pm

    Hi accounts_introtime,

    Sorry for late response. We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days.

    Yes we have our paid customization service, but if you want only to create a gauge chart we figure out how to achieve this. You can add one more column in table and fill all cells with number 1. (attachment 1)

    Then make a google gauge chart based on that table with these two columns and turn on option "Group chart" on "Formatting and preview" step of chart wizard and you will get chart how you requested.(attachment 2)

    Then you have to set in backend option "Default rows per page" to "All" and then all the data from table will be shown in chart on frontend.(attachment 3)

    You can make this in table based on mysql query.Take a look here how to do that.

    If you want to make this in table based on other data source, that requires code customization. 

    Kind Regards, 

    Isidora Markovic

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

    Amelia: FAQ | Facebook | Twitter |  Amelia demo sites | Docs

    You can try our wpDataTables add-ons before purchase on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables