Skip to main content
Question

Group by option lobby element error

  • May 25, 2022
  • 4 replies
  • 341 views

Forum|alt.badge.img+5

Hi!

 

I have created these Lobby Data Source +  Lobby Data element . And the Data source works but the Data Element doesn´t work ( I think that the “group by” option doesn´t work correctly). Below you can find the error message that appears in the Data element.  Thank you!

 

 

 




​​​​​

 

4 replies

Link
Superhero (Customer)
Forum|alt.badge.img+23
  • Superhero (Customer)
  • 1265 replies
  • May 25, 2022

Hi @mlizarralde 

it isn’t easy to identify the error. Your data source looks OK for me.

Could you move the cursor over your lobby element to show the error message?

For example:

 


Forum|alt.badge.img+5
  • Author
  • Sidekick (Customer)
  • 13 replies
  • May 25, 2022

HI!!!

 

this is the error message that appears in the lobby element

 

 


Forum|alt.badge.img+5
  • Author
  • Sidekick (Customer)
  • 13 replies
  • May 25, 2022

Just solved, I have used DISTINC instead of Group by and now the lobby element works

 

 


Link
Superhero (Customer)
Forum|alt.badge.img+23
  • Superhero (Customer)
  • 1265 replies
  • May 25, 2022

Hi @mlizarralde 

great, your select statement deliver 8 rows but a counter can only shows one.

But I think you can also change the aggregrate in your lobby element to sum and change the column to employee no.