https://reports.zoho.com/ZDBDataSheetView.cc?OBJID=315891000000006057&STANDALONE=true&privatelink=6bd22767f54b58f06f9d800d66afcd63&ZDB_THEME_NAME=blue&DATATYPESYMBOL=false&REMTOOLBAR=true
The first query I created shows the customers of the west sales that are greater than $2000. I also adjusted to show the sales in descending order of sales amounts.
Formula =
select"Customer Name","Product Category","Region","Sales" from "Sales" where "Sales">2000 and "Region" = 'West'
https://reports.zoho.com/ZDBDataSheetView.cc?OBJID=315891000000006169&STANDALONE=true&privatelink=55764c81f2b75685fa06418d11c95dab&ZDB_THEME_NAME=blue&DATATYPESYMBOL=false&REMTOOLBAR=true
The second query I created shows the customers of the east sales that are greater than $2000. I also adjusted to show the sales in descending order of sales amounts.
Formula =
select"Customer Name","Product Category","Region","Sales" from "Sales" where "Sales">2000 and "Region" = 'East'
The results showed that although there a higher average amount spent by the east, there were far more customer in the west (that had the minimum $2000 quota).
The graph that I made may not look as fancy as I had hoped but I edited in such detail that would only show east and west, as well as made it so it only took into the number of sales of over $2000.
https://reports.zoho.com/ZDBDataSheetView.cc?OBJID=315891000000004005&STANDALONE=true&privatelink=967e1a127979305d3a0d25f084042fca&ZDB_THEME_NAME=blue&REMTOOLBAR=true&INCLUDETITLE=true&INCLUDEDESC=true
No comments:
Post a Comment