cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
AlexS
Level III

Distribution not showing data in the column

Hello

 

I have written a Regex expression which populates data in a new column....no problem there.

the issue is when I then highlight the column and go to the ribbon and click on distribution icon sometimes the box will pop up where you select a column and other times it will go straight to the frequencies display box but both result in nothing displayed even though there is data in the column? it only happens on that particular column and it doesn't happen with other columns where I've used Regex.

Has anyone else experienced this? any solutions?

 

thanks

Alex is the name, Power BI/ SQL /JMP is my game
1 ACCEPTED SOLUTION

Accepted Solutions

Re: Distribution not showing data in the column

Regex() returns a character string. Distribution uses a continuous numeric data column. Is the data type and modeling type consistent?

View solution in original post

2 REPLIES 2

Re: Distribution not showing data in the column

Regex() returns a character string. Distribution uses a continuous numeric data column. Is the data type and modeling type consistent?

AlexS
Level III

Re: Distribution not showing data in the column

That was correct, it was actually the fact I had some hide and exclude on some of the rows. When I reverted it back it showed everything again. Unsure why it didn't just show me rows which were not excluded though?

Alex is the name, Power BI/ SQL /JMP is my game