Forum Discussion

Ayupchap's avatar
Ayupchap
Helper III
8 years ago
Solved

Issue with groups

HI all hope somone can help I have a large dataset and I was trying to create groups for one of the columns. I could create them in the grouping page as lists fne but when I press OK it shows the wor...
Need Help
Show and Tell
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Ayupchap,

     

    That case, would you please make the sample data more clear and more readable? Would you please show me the sample table as what I have posted above?

     

    If I understand corrently, value like "Grade 6 ELA #1 16 Book 1" is stored in a signle column, right? I think it won't matter. You can split it to multiple columns.

    Column2 = LEFT(Table3[Column1],17)
Column3 = RIGHT(Table3[Column1],LEN(Table3[Column1])-LEN(Table3[Column2]))

     

    Best regards,

    Yuliana Gu

Ayupchap's avatar
Ayupchap
Helper III
8 years ago

Oh wow thanks so much for this

 

Onyl issue is the assesment name and the book name is combined in one field unlike the way its displayed on your amazing example, do you think this will mater?

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi Ayupchap,

 

That case, would you please make the sample data more clear and more readable? Would you please show me the sample table as what I have posted above?

 

If I understand corrently, value like "Grade 6 ELA #1 16 Book 1" is stored in a signle column, right? I think it won't matter. You can split it to multiple columns.

Column2 = LEFT(Table3[Column1],17)
Column3 = RIGHT(Table3[Column1],LEN(Table3[Column1])-LEN(Table3[Column2]))

 

Best regards,

Yuliana Gu

  • Ayupchap's avatar
    Ayupchap
    Helper III
    8 years ago

    Apologies for not making it clear, the example you use here is exactly how I have it, this is really amazing thanks so much!  This totally solves my problem