Forum Discussion
Frequency Distribution Table Help
Hi huntj06,
For your requirement, I think you can create a calculated table based on raw table records to aggregate them based on date value and distinct product count.
All the secrets of SUMMARIZE - SQLBI
After these steps, you can add a calculated column to that table to mapping 'count of product' values to specific number range groups, then you can use the group as axis and 'count of product' as value to create the expected charts.
DC Product Range = IF ( [DC Product] >= 5, "5", IF ( [DC Product] >= 3, "3~4", IF ( [DC Product] >= 1, "1~2" ) ) )Regards,
Xiaoxin Sheng
I still do not understand how your table is connected to the chart. May be someone else does.
Sorry, let me try this:
The chart is a frequency distribution table with the axis being a binned / grouped set of values; those values are a COUNT of the number of times a PRODUCT is associated with a DATE. E.g, there's one product that is associated with 1 or 2 dates. There's 3 products associated with either 3 - 4 dates or 5 dates.
Hi,
Based on the data that you have shared, which is the 1 product associated with 1 or 2 dates? Please clarify.
Hello, Product G.