The chart interface allows a “grouping’ function where if you select grouping, all rows with the same label (eg George in the video tutorial) are summed (added together in an aggregation).
I need a similar feature but instead of grouping by sum, we would group by taking the average.
Is this possible? Seems like it would be an easy change on your end.
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
Unfortunately, at this time we don't have that functionality.
Our developers might work on it for the future, but i can't say an ETA on it.
Currently, you wouldn't be able to include an average if you group a column as that would be converted into a row, and the calculation functions are not available for rows, only columns.
Let me know if you have any questions or maybe if i didn't understand you intended goal correctly. Thank you.
On second thought, it is quite possible that i didn't exactly understand your intention. I will get a second opinion from senior colleagues, and as soon as i confirm this i will come back to you with more information.
After getting a second opinion from a senior colleague, he also confirms that this is, unfortunately not possible to achieve by any of our plugin capabilities at this time.
We will try to work to add this in the future, but i can't say if or when it will be possible. We will certainly do our best.
If you have any other questions or need assistance with something not related to this subject, please don't hesitate to open a new ticket and we will assist. Thank you
I am having trouble creating a statement for medians in the mysql query. I use
SELECT AVG(dd.val) as median_val
FROM (
SELECT d.2022_TO as val, @rownum:=@rownum+1 as `row_number`, @total_rows:=@rownum
FROM QuickTake_Turnover d, (SELECT @rownum:=0) r
WHERE d.2022_TO is NOT NULL
-- put some where clause here
ORDER BY d.2022_TO
) as dd
WHERE dd.row_number IN ( FLOOR((@total_rows+1)/2), FLOOR((@total_rows+2)/2) );
but it is not accepted. I get the error:
cannot calculate position of @total_rows:=@rownum within )/2), FLOOR((@total_rows+2)/2) );
As i mentioned on the other ticket, that was extremely delayed for the confirmation on the median subject ( apologies once more for that);
unfortunately, i had confirmation from the developers that currently our SQL & PHP parser is not able to process this functionality.
Our developers will do their best to implement that in the future, but i can't say an ETA on it. I will make sure to pass this to them, though, as my suggestion.
Just adding an upvote in this request. We have the same functionality requirement.
Eg. we have a column that is a rate (a Standard Deviation Value actually) that when in group we would like to show the average not to accumulate all the values. Sadly as the chart is being populated dynamically from the table view, we cannot compute this in our table.
I am wondering if/how we can add the average function for this column and use this in the chart instead.
If we had the ability to create a formula where in the average we have the number of rows displayed in the chart at a given time, we could just as well use this.
Thank you for adding your vote for the quicker development process of this feature - we will pass it to our developers, to know that more users are asking for it.
-
We can see what you mean. Unfortunately, currently using the average functionality for charts is not possible,
but our devs will do their best to come up with a solution for that as well, as soon as possible.
-
Right now, as you know, we only have the "Chart grouping", where a chart can count the values of the rows with the same label , to be summed up and rendered as a single series... but we don't have the "average" function for charts yet.
I continue to make great progress with your product! Consider me a fan!
I have a new question -- unrelated to below... but I'm having a hard time creating a new ticket, so putting it here:
I'm trying to use the Google Charts Waterfall chart. But not having success.
-Why do you require 5 columns of data? Clearly the first column is for the labels (e.g., years)... The second column can be for the values: For example:
Starting Balance: 10 Year 1: +4 Year 2: -1 Year 3: +2 Year 4: +6 Ending Balance: 21
I do this in Google Sheets with a Waterfall chart and it works perfectly. It's just 2 columns -- the titles and the values. Please explain
I believe I figured it out... Let me know if I have this right:
Column 1: label Column 2: Starting Value Column 3: Where you want the "movement" to to start Column 4: Where you want the movement to end (if column 4 is less then column 3, then it will be red; if greater, than it will be green) Column 5: Finishing Value
So others can have the benefit of documentation here:
Typically your first value (left most bar) will just be the starting value. Let's say it's $10. Then, your first row will have the following columns:
C1: "Starting Revenue" -- label C2: 10 -- you want the value to start at 10 C3: 0 -- saying you want the bar painted from 0 C4: 10 -- saying you want the bar painted to 10 C5: 10 -- saying you want the bar's finishing value to be 10
Next row will be the change. Let's say you want it going up +2, to 12.... then you'd have:
C1: "New Bookings" -- or whatever your label is C2: 10 -- saying the bar starts at 10 C3: 10 -- saying the movement starts at 10 C4: 12 -- saying the movement ends at 12 C5: 12 -- saying the ending value is 12
If the next row is a decrease then the values would look like:
And thank you for the kind words; we are happy to see that you are liking our plugin so far
We will cover your query here now;
I just have to ask you for the future,
when you have questions or issues which are not related to the title of the active ticket, please open a new ticket, and we will help you there.
In that way, issues and questions which are related to different subjects will be in separate tickets so other customers or our support agents can find them easily.
Our policy is to have one issue or question per ticket because of the reasons that are described already.
Thank you for understanding.
- I see that you tried to open a new ticket, can you tell us what was the issue, you said you had a hard time to make a new one?
-
Regarding the waterfall charts, to be fully honest with you, i see that they are a new addition and only available for Google Charts, i don't have any experience with them yet - so i will get help from senior 2nd level Team.
As you saw, on the Documentation, our developers stated that there should be only 1 column for string or date (will be used for vertical axis);
and other columns should have numerical values.
A minimum of 5 columns is required (4 numerical columns and one string or date column);
but that is not new information for you - of course.
-
I will report back once senior colleagues confirm if you got it correctly now - it seems to me that you got it perfect now;
and thank you for sharing this with us, so that other customers can see as well.
We will just review, and come back to confirm the information.
The chart interface allows a “grouping’ function where if you select grouping, all rows with the same label (eg George in the video tutorial) are summed (added together in an aggregation).
I need a similar feature but instead of grouping by sum, we would group by taking the average.
Is this possible? Seems like it would be an easy change on your end.
Hi, David
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
Unfortunately, at this time we don't have that functionality.
Our developers might work on it for the future, but i can't say an ETA on it.
Currently, you wouldn't be able to include an average if you group a column as that would be converted into a row, and the calculation functions are not available for rows, only columns.
Let me know if you have any questions or maybe if i didn't understand you intended goal correctly. Thank you.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
Hi, David
On second thought, it is quite possible that i didn't exactly understand your intention. I will get a second opinion from senior colleagues, and as soon as i confirm this i will come back to you with more information.
Thank you.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
Hi, David
After getting a second opinion from a senior colleague, he also confirms that this is, unfortunately not possible to achieve by any of our plugin capabilities at this time.
We will try to work to add this in the future, but i can't say if or when it will be possible. We will certainly do our best.
If you have any other questions or need assistance with something not related to this subject, please don't hesitate to open a new ticket and we will assist. Thank you
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
New Issue:
I am having trouble creating a statement for medians in the mysql query. I use
SELECT AVG(dd.val) as median_val FROM ( SELECT d.2022_TO as val, @rownum:=@rownum+1 as `row_number`, @total_rows:=@rownum FROM QuickTake_Turnover d, (SELECT @rownum:=0) r WHERE d.2022_TO is NOT NULL -- put some where clause here ORDER BY d.2022_TO ) as dd WHERE dd.row_number IN ( FLOOR((@total_rows+1)/2), FLOOR((@total_rows+2)/2) );
but it is not accepted. I get the error:
cannot calculate position of @total_rows:=@rownum within )/2), FLOOR((@total_rows+2)/2) );
Hi, David
As i mentioned on the other ticket, that was extremely delayed for the confirmation on the median subject ( apologies once more for that);
unfortunately, i had confirmation from the developers that currently our SQL & PHP parser is not able to process this functionality.
Our developers will do their best to implement that in the future, but i can't say an ETA on it. I will make sure to pass this to them, though, as my suggestion.
-
You can also create your suggestion on our suggestions page;
if nobody from the users has made that already, i will certainly do my best to push the feature as high as possible on the priority from my end.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
Just adding an upvote in this request. We have the same functionality requirement.
Eg. we have a column that is a rate (a Standard Deviation Value actually) that when in group we would like to show the average not to accumulate all the values. Sadly as the chart is being populated dynamically from the table view, we cannot compute this in our table.
I am wondering if/how we can add the average function for this column and use this in the chart instead.
If we had the ability to create a formula where in the average we have the number of rows displayed in the chart at a given time, we could just as well use this.
Hi, Dimitris
Thank you for adding your vote for the quicker development process of this feature - we will pass it to our developers, to know that more users are asking for it.
-
We can see what you mean. Unfortunately, currently using the average functionality for charts is not possible,
but our devs will do their best to come up with a solution for that as well, as soon as possible.
-
Right now, as you know, we only have the "Chart grouping", where a chart can count the values of the rows with the same label , to be summed up and rendered as a single series... but we don't have the "average" function for charts yet.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
Milo-
I continue to make great progress with your product! Consider me a fan!
I have a new question -- unrelated to below... but I'm having a hard time creating a new ticket, so putting it here:
I'm trying to use the Google Charts Waterfall chart. But not having success.
-Why do you require 5 columns of data? Clearly the first column is for the labels (e.g., years)... The second column can be for the values: For example:
Starting Balance: 10
Year 1: +4
Year 2: -1
Year 3: +2
Year 4: +6
Ending Balance: 21
I do this in Google Sheets with a Waterfall chart and it works perfectly. It's just 2 columns -- the titles and the values. Please explain
I believe I figured it out... Let me know if I have this right:
Column 1: label
Column 2: Starting Value
Column 3: Where you want the "movement" to to start
Column 4: Where you want the movement to end (if column 4 is less then column 3, then it will be red; if greater, than it will be green)
Column 5: Finishing Value
So others can have the benefit of documentation here:
Typically your first value (left most bar) will just be the starting value. Let's say it's $10. Then, your first row will have the following columns:
C1: "Starting Revenue" -- label
C2: 10 -- you want the value to start at 10
C3: 0 -- saying you want the bar painted from 0
C4: 10 -- saying you want the bar painted to 10
C5: 10 -- saying you want the bar's finishing value to be 10
Next row will be the change. Let's say you want it going up +2, to 12.... then you'd have:
C1: "New Bookings" -- or whatever your label is
C2: 10 -- saying the bar starts at 10
C3: 10 -- saying the movement starts at 10
C4: 12 -- saying the movement ends at 12
C5: 12 -- saying the ending value is 12
If the next row is a decrease then the values would look like:
C1: label
C2: 12
C3:12
C4:9
c5:9
etc.
Hi, David
Firstly i wish to apologise for the waiting time.
-
And thank you for the kind words; we are happy to see that you are liking our plugin so far
We will cover your query here now;
I just have to ask you for the future,
when you have questions or issues which are not related to the title of the active ticket, please open a new ticket, and we will help you there.
In that way, issues and questions which are related to different subjects will be in separate tickets so other customers or our support agents can find them easily.
Our policy is to have one issue or question per ticket because of the reasons that are described already.
Thank you for understanding.
- I see that you tried to open a new ticket, can you tell us what was the issue, you said you had a hard time to make a new one?
-
Regarding the waterfall charts, to be fully honest with you, i see that they are a new addition and only available for Google Charts, i don't have any experience with them yet - so i will get help from senior 2nd level Team.
As you saw, on the Documentation, our developers stated that there should be only 1 column for string or date (will be used for vertical axis);
and other columns should have numerical values.
A minimum of 5 columns is required (4 numerical columns and one string or date column);
but that is not new information for you - of course.
-
I will report back once senior colleagues confirm if you got it correctly now - it seems to me that you got it perfect now;
and thank you for sharing this with us, so that other customers can see as well.
We will just review, and come back to confirm the information.
Thank you
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
Hi, David
Thank you for your patience. I got advised on this by our 2nd level Team.
You have absolutely nailed it with this solution, that is how it should be for the Google Charts Waterfall chart.
Thank you for sharing that with us - we are sure it will be useful as an example for other users who need a similar solution for their project.
Of course, if you find any more examples that you wish to share, please feel free to do so, we are making a note of this.
Thanks again.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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