Combine columns under category group - Pie chart


  • Hi,

    I have a pie chart thats taking data from one of the dataset. My dataset has around 7 columns. Columns-A,B,C,D,E,F,G

    In Pie chart data under values- I am taking the count of two columns under values(= Count(A)+Count(B)). But for Category group i want to combine the two columns data as well column C and Column D. Can i combine the two columns data?

    Friday, February 9, 2018 9:12 PM

All replies

  • you can if you bring the expression as a derived column in the dataset

    i.e in your query

    ColumnC + ColumnD AS ColumnH

    and use H for category groups

    Also make sure you handle NULL values in them in case there are nullable

    Please Mark This As Answer if it solved your issue
    Please Vote This As Helpful if it helps to solve your issue
    My Wiki User Page
    My MSDN Page
    My Personal Blog
    My Facebook Page

    Saturday, February 10, 2018 6:15 AM
  • Hi,

    To combine two columns data to make it category group, you could use calculated field. 

    Then you can treat it like the original fields in the dataset. 



    • Proposed as answer by Henry Jiang Monday, February 12, 2018 1:38 AM
    Monday, February 12, 2018 1:38 AM
  • I tried calculated field but it does not work for my case.

    My data is like below-

    A C B D E F G
    Test Ex-1 Test Ex-4      
    Test Ex-2 Test Ex-5      
    Test Ex-3 Test Ex-5      

    Test1 Ex-2 Test1 Ex-5      
    Test1 Ex-2 Test1 Ex-5      
    Test1 Ex-1 Test1 Ex-5

    i am doing count of A and B on the value property of pie chart. In the category group i want to combine C and D columns.

    So the slices of pie should show count- 1 for Ex-1, 1-Ex-2,1 for Ex-3,1-Ex-4,2 for Ex-5 on every slice.similarly for Test1.

    • Edited by Papil1 Monday, February 12, 2018 3:09 PM more precise example
    Monday, February 12, 2018 2:39 PM