Forum Discussion
Solved
Frequency Distribution Table Help
I’m attempting to come up with a frequency distribution that enables me to create a visual that shows how many data points meet a specified result. I have two columns in a table named DATE and PRODUC...
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
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.