Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I have to create a bubble chart with No of Stores in x axis , Sales in Y axis and the size of the bubble with the Number of Transactions.
Please let me know how to do this.
Thanks
Boopesh
You can use a scatter chart for this with three expressions:
Count(distinct Stores)
Sum(Sales)
Count(distinct Transactions)
I have no idea what you want to use as dimension. You haven't given any information regarding that.
My Dimension would be Region. Where one Region will have many Stores.
And the question is how to determine that the size of the bubble is to be on Transaction count. ?
Combo Chart is also a option
Its upto Business requirement and Users...
1) Bubble size can be defiend on the base of Sales like =sum(Sales)
2) Bubble size can be defiend on the base of number of transaction like =Count(TransactionID) or Count(TransactionDate) //use distinct if required
3) Bubble size can be defiend on the base of Stores like =Count(StoreID) //Use distinct if required