I then want them to go to a simple bar chart with three types of bar: Apples, Pears, Oranges.
It's easy for my users to see Date v Quantity, but how do I get them to see three separate coloured bars, one for each of the different types of fruit.
The solution must not allow the user to see other users values.
More Detailed Explanation
I am not a developer, but I have a good understanding of databases and an amateurs MySQL ability.
I am building a simple user table with charts for meditation.
In the table I have three main fields; date, minutes, plan.
In the 'plan' field, I want my users to select one of two values, (Plan or Done)
I have created a chart that shows the end-user how many minutes they meditate each day. It's a simple bar chart, showing date v minutes.
But, what I really want is a chart that shows two bars, Plan and Done.
So my users can compare what they planned against what they did.
I know the easiest thing to do is to create more fields, but this is just one of three similar scenarios, (guided or unguided), (type of meditation, with several different values), which I would also like to add to charts.
If I can solve this for the 'plan' field (plan or done), then I can use the same solution for the other two fields, (assuming the solution will work for multiple values)
I created some simple queries to break the minutes into two separate fields based on a simple CASE query which I then joined.
But, when I used this as a source table for the chart it would not allow users to see their own values.
The solution must not allow the user to see other users values.
I am sure there is a simple solution to this, but I am an enthusiastic amateur who has spent 3 days trying to solve this problem. The plugin is incredible.
I am still in awe of the ability to create a table that users can only see what they edit. But I have come to appreciate that I can only display a manual table and not a table generated from a SQL query. If that is correct and I am limited to only the fields I can enter manually, (and which must be integers if I want any ability to create any functions). Then I accept that I will have to create a field for every 'fruit' I want to display in a chart. Unless there is a workaround, I understand that I can't have one field for 'fruit', and 'lookup' or calculated fields to display each type of fruit.
Thank you very much for your interest in our plugin.
The chart engines we use accept only one string-type column (strings, URL, email, etc), so all other columns need to be integers or floats.
If you can't get the result you need from this table, you will need to restructure it, to be able to create the desired chart with it.
If you managed to make it work, "Follow table filtering" needs to be enabled on the chart and the table needs to be on that page as well (similar to what's already done here).
Now, what did you mean by "I have come to appreciate that I can only display a manual table and not a table generated from a SQL query".
If the SQL query based table is editable, you can use the same feature. For it to be editable, you need to have an auto-increment column for ID column for table editing, and that server-side processing needs to be turned on.
BTW - Awesome App for a wannabe website builder.
Easy Explanation
I want my users to enter into a table;
Date, Quantity, Fruit (Apples, Pears, Oranges)
I then want them to go to a simple bar chart with three types of bar: Apples, Pears, Oranges.
It's easy for my users to see Date v Quantity, but how do I get them to see three separate coloured bars, one for each of the different types of fruit.
The solution must not allow the user to see other users values.
More Detailed Explanation
I am not a developer, but I have a good understanding of databases and an amateurs MySQL ability.
I am building a simple user table with charts for meditation.
In the table I have three main fields; date, minutes, plan.
In the 'plan' field, I want my users to select one of two values, (Plan or Done)
I have created a chart that shows the end-user how many minutes they meditate each day. It's a simple bar chart, showing date v minutes.
But, what I really want is a chart that shows two bars, Plan and Done.
So my users can compare what they planned against what they did.
I know the easiest thing to do is to create more fields, but this is just one of three similar scenarios, (guided or unguided), (type of meditation, with several different values), which I would also like to add to charts.
If I can solve this for the 'plan' field (plan or done), then I can use the same solution for the other two fields, (assuming the solution will work for multiple values)
The pages in question are:
https://the-four-rooms.com/my-plan-meditate/
(other fields will be added if I can resolve this problem)
with the chart at:
https://the-four-rooms.com/results/
I created some simple queries to break the minutes into two separate fields based on a simple CASE query which I then joined.
But, when I used this as a source table for the chart it would not allow users to see their own values.
The solution must not allow the user to see other users values.
I am sure there is a simple solution to this, but I am an enthusiastic amateur who has spent 3 days trying to solve this problem. The plugin is incredible.
Thank You.
I am still in awe of the ability to create a table that users can only see what they edit. But I have come to appreciate that I can only display a manual table and not a table generated from a SQL query. If that is correct and I am limited to only the fields I can enter manually, (and which must be integers if I want any ability to create any functions). Then I accept that I will have to create a field for every 'fruit' I want to display in a chart. Unless there is a workaround, I understand that I can't have one field for 'fruit', and 'lookup' or calculated fields to display each type of fruit.
Hi Jarry
Thank you very much for your interest in our plugin.
The chart engines we use accept only one string-type column (strings, URL, email, etc), so all other columns need to be integers or floats.
If you can't get the result you need from this table, you will need to restructure it, to be able to create the desired chart with it.
If you managed to make it work, "Follow table filtering" needs to be enabled on the chart and the table needs to be on that page as well (similar to what's already done here).
Now, what did you mean by "I have come to appreciate that I can only display a manual table and not a table generated from a SQL query".
If the SQL query based table is editable, you can use the same feature. For it to be editable, you need to have an auto-increment column for ID column for table editing, and that server-side processing needs to be turned on.