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)

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

      What is the relationship between these tables? If you create proper relationships on columns in these tables, this should also work.