viatechcenter
viatechcenter
Could you please send me videos, images or step by step chart configuration?
Thanks a lot
Thanks a lot
-
New Commercial Services Section
We have now opened a commercial services section here on the forum for registered users. If you have a Fabrik project that you wish to have someone work on for you, post it under Help Wanted. If you are an application developer and wish to earn some money helping others, post your details under Fabrik Application Developers.
Both of these are unmoderated. It will be up to both parties to work out the details and come to an agreement.
-
Joomla 5.1
For running J!5.1 you must https://fabrikar.com/forums/index.php?wiki/update-from-github/ or include the new file manually https://fabrikar.com/forums/index.php?threads/joomla-5-1-and-fabrik-cannot-find-files-error.54473/post-285151 See also Announcements
Chart Visualization examples
- Thread starter viatechcenter
- Start date
viatechcenter
viatechcenter
viatechcenter
viatechcenter
My website is http://oficialesdebackus.com/
I need to work with fusion charts visualizations.
Table Evaluation with these fields:
- product1, product2, product3 (dropdown)
- price1 (field)
- price2 (field)
- yes, not (radio buttom)
Table Customers with these fields:
- city1, city2, city3, city3, city4, city5, city6 (field)
- week1, week2, week3, week4 (dropdown)
I need to create these Graphics:
Graphic 1: product(x) / price(x) / yes or not / city(x) / week (x)
Graphic 2: product(x) /city(x)
Graphic 3: product(x) / week(x)
Graphic 4: product(x) / yes or not
Graphic 4: product(x) / price
Thanks Rob for your help
I need to work with fusion charts visualizations.
Table Evaluation with these fields:
- product1, product2, product3 (dropdown)
- price1 (field)
- price2 (field)
- yes, not (radio buttom)
Table Customers with these fields:
- city1, city2, city3, city3, city4, city5, city6 (field)
- week1, week2, week3, week4 (dropdown)
I need to create these Graphics:
Graphic 1: product(x) / price(x) / yes or not / city(x) / week (x)
Graphic 2: product(x) /city(x)
Graphic 3: product(x) / week(x)
Graphic 4: product(x) / yes or not
Graphic 4: product(x) / price
Thanks Rob for your help
rob
Administrator
what is product(x) - is that a sum of sales, the number of sales?
is the bits going after the / the Y axis?
Sorry but its not clear to me what it is you need still.
I really don't understand that table, what are the 6 cities for, are they checkboxes, fields etc?
Same things for the week - what are they for? How do they relate to customers :S
Please take the time to formulate your question as clearly as possible, whilst for you its obvious what you need, for me coming at it from a cold start, I need things clearly spelt out to me.
is the bits going after the / the Y axis?
Sorry but its not clear to me what it is you need still.
I really don't understand that table, what are the 6 cities for, are they checkboxes, fields etc?
Same things for the week - what are they for? How do they relate to customers :S
Huh? I have no idea what that means!
Please take the time to formulate your question as clearly as possible, whilst for you its obvious what you need, for me coming at it from a cold start, I need things clearly spelt out to me.
viatechcenter
viatechcenter
Rob, sorry about my bad approach.
It, really, is a pool very simple.
product(x) is a dropdown, a product name, not a sum of sales.
Product1 -> Toyota
Product2 -> Ford
Product3 -> Mazda
About cities:
- city1, city2, city3, city3, city4, city5, city6 (text fields)
Pollster will write city name in a text field.
Weeks
Pools are made by weeks.
For example:
how many type of cars (Toyota) were sold in a week 1
how many Fords were sold in week 1... and so on.
The same, if I like to know when Toyotas were sold in New Jersey (city 1) or New York (city 2)... and so on.
Another Graphic:
I like to know the price were sold Toyotas in New Jersey in week 1 and if this store sold this car (Toyota) to regular price (yes or not radio buttom).
Tables:
In Table 1 are cities (text field) and weeks (dropdown)
In Table 2 are products (dropdown), yes or not (radio buttom) and price sold (text field).
I hope this more clear.
Thanks for your help.
It, really, is a pool very simple.
product(x) is a dropdown, a product name, not a sum of sales.
Product1 -> Toyota
Product2 -> Ford
Product3 -> Mazda
About cities:
- city1, city2, city3, city3, city4, city5, city6 (text fields)
Pollster will write city name in a text field.
Weeks
Pools are made by weeks.
For example:
how many type of cars (Toyota) were sold in a week 1
how many Fords were sold in week 1... and so on.
The same, if I like to know when Toyotas were sold in New Jersey (city 1) or New York (city 2)... and so on.
Another Graphic:
I like to know the price were sold Toyotas in New Jersey in week 1 and if this store sold this car (Toyota) to regular price (yes or not radio buttom).
Tables:
In Table 1 are cities (text field) and weeks (dropdown)
In Table 2 are products (dropdown), yes or not (radio buttom) and price sold (text field).
I hope this more clear.
Thanks for your help.
rob
Administrator
Your set up still sounds pretty odd to me - are you dead set on the way its done, or can I suggest something a little cleaner?......
It seems to me you have three 'objects' you need to track/use in your application:
* Products
* Cities
* Sales
Each 'object' should thus have its own database table and corresponding Fabrik list with the following fields:
================
Products
================
id
label
================
Cities
================
id
label
================
Sales
================
id
product_id - database join element to the products list
city_id - database join element to the cities list.
date - date element
yesno -not sure what this field represents but you mentioned it previously so I'm including it
price
I would say its best to store the date of the sales and not the week number as that can be inferred from the date, and storing the date means other analysis is possible (e.g. sales by year/month etc)
If you'r ok with that set up then I can elaborate to describe the graphs
It seems to me you have three 'objects' you need to track/use in your application:
* Products
* Cities
* Sales
Each 'object' should thus have its own database table and corresponding Fabrik list with the following fields:
================
Products
================
id
label
================
Cities
================
id
label
================
Sales
================
id
product_id - database join element to the products list
city_id - database join element to the cities list.
date - date element
yesno -not sure what this field represents but you mentioned it previously so I'm including it
price
I would say its best to store the date of the sales and not the week number as that can be inferred from the date, and storing the date means other analysis is possible (e.g. sales by year/month etc)
If you'r ok with that set up then I can elaborate to describe the graphs
viatechcenter
viatechcenter
viatechcenter
viatechcenter
Rob, I am ok with you recommendation.
Please, describe the graphs.
Thanks
Please, describe the graphs.
Thanks
viatechcenter
viatechcenter
Rob, any help?
rob
Administrator
Here's an example of a nvd3 vis 'discrete chart' http://demo.fabrikar.com/index.php/sales-chart
based on the data structure I previously outlined.
I had to tweak the viz code to get this to work, so you will need to update from github.
Here's a video of the viz settings I used:
http://screencast.com/t/6LuuSNqlZR
based on the data structure I previously outlined.
I had to tweak the viz code to get this to work, so you will need to update from github.
Here's a video of the viz settings I used:
http://screencast.com/t/6LuuSNqlZR
viatechcenter
viatechcenter
Rob, I am waiting your help.
viatechcenter
viatechcenter
Rob, I checked your demo.
Is possible make this graph in fusion chart?
Thanks
Is possible make this graph in fusion chart?
Thanks
rob
Administrator
It more fussy to use the fusion charts plugin, as you may end up having to create copies of the list for each chart you want to make ....
however in principle to re-create my example in fusion charts you would need to edit the sales element and assign it a list sum calculation split on the city.
then create a chart
as per this video http://screencast.com/t/gaXCyKVY
the chart is here http://demo.fabrikar.com/index.php/sales-per-month-fusion
however in principle to re-create my example in fusion charts you would need to edit the sales element and assign it a list sum calculation split on the city.
then create a chart
as per this video http://screencast.com/t/gaXCyKVY
the chart is here http://demo.fabrikar.com/index.php/sales-per-month-fusion