Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello Experts,
I want to create dynamic group table basis my input. For example if i enter = 10, i get below table .. no. of rows are static, in this example .. rows are 15 :
Solved! Go to Solution.
Could we do something with a couple of input tables like in the attached? I got it to calc the low end and high end based on muliplying the group row * the selected segment.
What are you wanting to put into the groups? # of customers based on some other measure? What are the possible segment steps? I put my example at 1, 2, 3, 4, 5, 10, 15, 20, 25, 50.
How is the input value determined? Also, how do you know how many S.No's there are going to be? Is it always 15?
Do you need this as a table, or just an output value? How are you trying to use it?
I have sales data, now my requirement is that if i enter segment range like 10, then first it creates groups like below (total number of groups will remain 15 always ...) , now under groups I want to show the count customers falling...
here I am unable to create dynamic range :
Hi,
I cannot create the Groups based on a user defined interval. However, if we can treat the Groups as a static input, i can segment the customers in the groups.
Could we do something with a couple of input tables like in the attached? I got it to calc the low end and high end based on muliplying the group row * the selected segment.
What are you wanting to put into the groups? # of customers based on some other measure? What are the possible segment steps? I put my example at 1, 2, 3, 4, 5, 10, 15, 20, 25, 50.
Thank you @jdbuchanan71 , have the same thougts but unable to implement.... thanks a lot again
Hi,
May be - not sure as yet. Will need some data to work with.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |