I'm getting ready to add data to my table, but I need to know if I need to add a field to make this work. I would like to get totals by month for a chart. How do I need to format my table? I have Entry date and premium amount as columns, do I need anything else? Would I create the calculation on the table or on the chart?
Since you have columns "Entry Date" and "Premium Amount", I'm guessing the totals by month would be at the end of the rows, correct?
For example, you have a row with dates, and values for those dates, and you'd like to calculate the sum within that row? This could be done with Formula (Calculated) columns.
If, on the other hand, you want to calculate the sum of the column, you can take a look at calculation functions.
Or, am I missing something here? If so, can you please provide me with some examples, screenshots or screen recordings of what you're trying to achieve?
So I haven't added all the data to the table quite yet, but we have multiple entries on different days over the course of the last year. So the calculation needs to read the entry date, and collect all of the entries between 1/1 and 1/31 (for example) and total them, and do the same for all the entries between 2/1 and 2/28. Does that make sense?
However, I am sorry to disappoint you, but unfortunately something like this is not possible with the plugin's built in features.
Conditional formatting between columns is not yet possible with our plugin, so you can't add a rule where integer column would look for certain month, and then calculate the sum only for that month.
What you'd be able to do is to add every month as an INTEGER type column, and then just calculate the total for that column. I don't suppose this would be very useful, since you'd have a lot of columns, but that's the only way of displaying what you want to display.
I'm getting ready to add data to my table, but I need to know if I need to add a field to make this work. I would like to get totals by month for a chart. How do I need to format my table? I have Entry date and premium amount as columns, do I need anything else? Would I create the calculation on the table or on the chart?
Thank you.
Hello getbenefits.
Thank you for your purchase.
Since you have columns "Entry Date" and "Premium Amount", I'm guessing the totals by month would be at the end of the rows, correct?
For example, you have a row with dates, and values for those dates, and you'd like to calculate the sum within that row? This could be done with Formula (Calculated) columns.
If, on the other hand, you want to calculate the sum of the column, you can take a look at calculation functions.
Or, am I missing something here? If so, can you please provide me with some examples, screenshots or screen recordings of what you're trying to achieve?
Best regards.
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
So I haven't added all the data to the table quite yet, but we have multiple entries on different days over the course of the last year. So the calculation needs to read the entry date, and collect all of the entries between 1/1 and 1/31 (for example) and total them, and do the same for all the entries between 2/1 and 2/28. Does that make sense?
Understood, getbenefits.
However, I am sorry to disappoint you, but unfortunately something like this is not possible with the plugin's built in features.
Conditional formatting between columns is not yet possible with our plugin, so you can't add a rule where integer column would look for certain month, and then calculate the sum only for that month.
What you'd be able to do is to add every month as an INTEGER type column, and then just calculate the total for that column. I don't suppose this would be very useful, since you'd have a lot of columns, but that's the only way of displaying what you want to display.
I am sorry for any inconvenience.
Best regards.
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