Bar/Line View: parallel measures, Average Cost for top 10 firms
-
I am trying to display in a bar chart, a list of top 10 cutomers, by number of orders, left to right. In the same chart I would also like to view each of their average order amounts.
In my raw data I have each order for each customers with each order cost.
Does anyone know how I could do this?
Thanks in advance John -
2 Comments
-
Your measures, in the Bar/Line View, should be [Order ID] and [Order value], with functions Non-empty count and Mean. The Split choice should be [Customer ID]. You can click on the option to use secondary axis, so you can display different scales for the 2 measures on the same chart (on the Measures menu, next to the variable).
On the Split menu, Limit Values option, you can decide how many values to include.
Welcome!
It looks like you're new here. If you want to get involved, click one of these buttons!
Categories
- All Discussions2,595
- General680
- Blog126
- Support1,177
- Ideas527
- Demos11
- Power tips72
- 3.0 preview2
Tagged
To send files privately to Visokio email support@visokio.com the files together with a brief description of the problem.