Dynamic Category for Pie Chart

Q&A
, , , ,
1

Hi,

Users want to get the part to total % data and the make the category dynamic. Ex: Users want to be able to select if they want to see : The % of sellers in region A. or The % of sellers in region A with Account B etc.
Do we have a bar chart or other charts to achieve this data slice and dice?
Ex: showing below, the highlighted are one kind of combination example we want users to be able to choose.

image
image1023×306 42 KB

2

Hi @Cindy
couldnt you just use a filter for Region and Account?
BR

3

How can you calculate the part to total % and visualize that with filters?

4

maybe you can create a sample set of data in Arena we can work with?

5

Hi Erick,
Sending you the sample data, please advice how we can build the chart. users are asking if we can have a pie charts to present this part to total %. but make the way to aggregate the data be dynamic. for example: for the yellow highlighted part, users want to choose their own combinenations to view the data. Like ’ biz_unit + geo’ or ’ geo + region’

image
image758×267 35.3 KB

year_month biz_unit geo region sub_region segment sub_segment sfdc_customer_id customer_name csm_no industry csm tas rev_gar_sum_last_12_months
6/1/2020 PS AMER US GOVTECH US GOVTECH STR ENT GOVTECH 0015000000kNjSbAAK A 2 Manufacturing With CSM 13555380 1361.067356
6/1/2020 CS AMER SMB ENG-SW-CSC SMB SMB CORE 0013800001CDnnEAAT b 0 Other Without CSM 216311.11 115.887239
6/1/2020 CS AMER SMB NE-NORTHEAST SMB SMB LARGE 0015000000cvQApAAM c 2 Life Sciences With CSM 3937061.8 39751.82544
6/1/2020 CS EMEA BENELUX NL SMB SMB CORE 0010z00001ZcE3YAAV d 0 Retail, Wholesale & Distribution Without CSM 59940 1995.563835
6/1/2020 CS EMEA UKIR IE DNB DNB LARGE 00150000013XsoPAAS e 0 Telecommunications Without CSM 147931360 0
6/1/2020 CS AMER SMB NE-NORTHEAST SMB SMB LARGE 0015000000cvQApAAM b 3 Life Sciences With CSM 3937061.8 0
6/1/2020 PS GLBL AEROSPACE & SAT SATCOM ENT AMER SATSOL - SATCOM 0013800001MqFACAA3 f 0 Telecommunications Without CSM 11817704 2877.450317
6/1/2020 CS APAC INDIA FSI ENT ENT LARGE 0010z00001bL28qAAC d 0 Financial Services Without CSM 46017124 10893.28864
6/1/2020 CS EMEA BENELUX NL SMB SMB CORE 0010z00001ZcE3YAAV g 0 Retail, Wholesale & Distribution Without CSM 59940 0
6/1/2020 CS APAC ASEAN VN ENT ENT LARGE 0013800001B9B2RAAV b 1 Financial Services With CSM 4263582.5 0
6/1/2020 CS AMER CANADA SMB CENTRAL-ROO SMB SMB CORE 0010z00001a75yaAAA h 0 Healthcare Without CSM 337740.8 0
6/1/2020 CS EMEA UKIR UK SUP STARTUP EMERGING 0010z00001axCkEAAU d 0 Financial Services Without CSM 30121.95 0
6/1/2020 CS EMEA DACH DE SMB SMB LARGE 0015000000wp4dQAAQ i 0 Entertainment Without CSM 767464.75 0
6/1/2020 CS EMEA DACH DE ENT ENT MIDSIZE 0013800001MqF3fAAF b 0 Manufacturing Without CSM 6579074.5 8166.407516
6

Hey @Cindy ,

I’m not sure how dynamically we could build something like this.
An option would be to create something like:
concat(
ifelse(
pParameter=‘biz_unit’, biz_unit, all the other possible field, NULL),
’ ‘,
ifelse(
pParameter2=biz_unit’, biz_unit, all the other possible field, NULL)
)
You could add more parameter for the concat so it could be more dynamic.
Hopefully that can help you.
BR
Robert

7

Thanks for the solution Robert!