cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
Choose Language Hide Translation Bar
View Original Published Thread

Distribution not showing data in the column

AlexS
Level III

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