Solved

Create Counter Lobby from saved search with grouping

M
Rank
Userlevel 2
Badge +5

Hi!

I have created a very simple Lobby data source→

 

But when I try to link it with  a Counter element , it doesn´t work→

 

 

 

Could you help me please? 

 

thank you!

 

 

 

icon

Best answer by Himasha Abeywickrama 6 May 2021, 13:08

View original
This topic has been closed for comments

12 replies

Himasha Abeywickrama
Rank
Userlevel 7
Badge +18

Hi @mlizarralde,

 

Try selecting the correct column that you need to show the count for rather than leaving it as ‘all columns’ in the data section of the element designer.

https://www.linkedin.com/in/himashaabeywickrama
M
Rank
Userlevel 2
Badge +5

hi!!!

 

I have tried it.. but it doesn´t work…

 

thank you!

Himasha Abeywickrama
Rank
Userlevel 7
Badge +18

Hi @mlizarralde,

 

Remove the Group By condition from the Data source and it will work.

https://www.linkedin.com/in/himashaabeywickrama
M
Rank
Userlevel 2
Badge +5

but I need to group it, this is the poblem.  I need to see the number of different part number grouped (not duplicated)...

Himasha Abeywickrama
Rank
Userlevel 7
Badge +18

 

Hi @mlizarralde,

 

I believe what you’re trying to get is the distinct value of the part numbers. You can do that by changing the column of the data source like below,

Also, make sure to remove the Group By condition since we do not need to group it now.

https://www.linkedin.com/in/himashaabeywickrama
N
Rank
Userlevel 7
Badge +11

Hi @mlizarralde ,

 

You need to group and count in the data source level itself. Below is a sample setup I just tried.

 

After that in the element level it should be a matter of display (I have attached my output).

 

Hope this helps.

 

2 Attachments
- Nalaka -
M
Rank
Userlevel 2
Badge +5

Thank you @Nalaka Samarasinghe !

 

and would be possible to do it but using a Counter element, instead of a List element?

 

 

 

 

M
Rank
Userlevel 2
Badge +5

Thank you @Himasha Kapugeekiyanage    it works in Data Source →

 




But it does´n work using Counter element… :-(


 

 

Himasha Abeywickrama
Rank
Userlevel 7
Badge +18

Hi @mlizarralde,

 

Since we are getting the distinct values now, you don’t need to have the Group By condition. Please remove that and try again.

 

https://www.linkedin.com/in/himashaabeywickrama
M
Rank
Userlevel 2
Badge +5

Thank you very much @Himasha Kapugeekiyanage !!!! it works!!

 

 

Himasha Abeywickrama
Rank
Userlevel 7
Badge +18

Hi @mlizarralde,

 

Great news! Glad i could help.

Have a great day!

https://www.linkedin.com/in/himashaabeywickrama
N
Rank
Userlevel 7
Badge +11

 @mlizarralde, As per my knowledge, ‘Count’ element is supposed to show 1 count of all the data fetched to the selected data source, not for grouping. As in number of absences, number of purchase orders etc..

If you want to show more than 1 count, grouped for multiple categories, then ‘Count’ element might not be the option.

- Nalaka -
Terms & ConditionsCookie settings