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