Forum Discussion

abadi_89's avatar
abadi_89
Frequent Visitor
5 years ago

Grouping count by value per category

  Hello all, How may I get such results?   Will stacked % bars give such? how to group these count range? Thanks alot.   Invoice (table) - Value (column) CDTs (table) - Category (column...
Need Help
  • abadi_89's avatar
    abadi_89
    Frequent Visitor
    5 years ago

    Thank you amitchandak ,
    I managed to make the bucketing but couldn't manage to after? it won't go to the visual!
    Any ideas?

    • v-jingzhang's avatar
      v-jingzhang
      Community Support
      5 years ago

      Hi abadi_89 

      It seems your Segmentation is a measure. In order to use segmentation as category in a bar chart, you need to create a calculated column for segmentation instead of a measure because measures cannot be put in Legend or Axis fields of a chart. For example,

      Regards,

      Jing

      • abadi_89's avatar
        abadi_89
        Frequent Visitor
        5 years ago

        Thank you!

        Now it make sense, any idea how to create that column if the region is in another table?

        What I have is:

        Invoice (table) - Value (column)

        CDTs (table) - Category (column)

        Vendor (table) - Supplier name (column)