Group by range for results of DISTINCT COUNT in matrix

[IoannisT]

Hi Faboulous comunity!

I have the following request which the more I read about it, the more confused I get.

I have a visual (matrix) where I select my Rows, Columns and Values (later in DISTINCT COUNT).

All works fine but now I need to group these in diferent ranges. 
See attached:

	Date					
Product	01/06/2024	02/06/2024	03/06/2024	04/06/2024	05/06/2024	06/06/2024
asd		100		50	10	550
xcv	1	250		50	10	450
wer		270	9	150	10	450
fgh	15	450	9	150	10	350
rty	13		105	150	10	25

Group	Min_RG	Max_RG
1-10	1	10
11-20	11	20
21-30	21	30
31-50	31	50
51-100	51	100
101-500	101	500
>501	501	

How do you suggest I approach this?

[ThxAlot]

[IoannisT]

Hi @ThxAlot 

Althought your solution works for "value", it does not work for "distinct count" text.

Perhaps when I gave the tables, I didn't write it in a clear manner that this is the Matrix visual, not the source.

The data set is a large table like

Customer ID   |    Date   |  Receipt ID | oher fields...etc etc

 On the matrix visual, I put on "Rows" -> "Customer ID", "Columns" -> "Date", and "Values" -> "Reciept ID" in a DISTINCT COUNT selection.

Data could be

Customer ID   |    Date             |  Receipt ID |

aaa                 |  30/06/2024    | rid001

aaa                 |  30/06/2024    | rid001

aaa                 |  30/06/2024    | rid002

aaa                 |  30/06/2024    | rid003

aaa                 |  30/06/2024    | rid004

in the above scenario, my matrix correctly shows:

CustomerID |    Date             |  30/06/2024  | 01/07/2024 |  02/07/2024 |  03/07/2024 |

aaa                                        |         4           |                     |                      |                     |


Although when I try your solutions with other numerical column, it works, I am in search for a solution for the above example

[Ashish_Mathur]

Hi,

This is dynamic segmentation.  Refer to the attached file.

Hope this helps.