Count based on previous column value

Stimulsoft Reports.JS discussion
Post Reply
s.wieczorek
Posts: 19
Joined: Fri Sep 22, 2017 5:06 am

Count based on previous column value

Post by s.wieczorek »

Hi,
How can i do distinct count based on a value from a previous column?
Attachments
screen_grouping.jpg
screen_grouping.jpg (15.61 KiB) Viewed 2878 times
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Count based on previous column value

Post by HighAley »

Hello.

There is a CountDistinct function that you could use.

Thank you.
s.wieczorek
Posts: 19
Joined: Fri Sep 22, 2017 5:06 am

Re: Count based on previous column value

Post by s.wieczorek »

Yes, I've seen it. But how to use it with some kind of parameter from the value of the previous column? For example, I need Count where language == ENGLISH (dynamically). I'm connecting to OData service that is pulling data from MongoDB
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Count based on previous column value

Post by HighAley »

Hello.

Please, send us your report template with sample data.
We need to reproduce the issue to give you more detailed answer.

Thank you.
s.wieczorek
Posts: 19
Joined: Fri Sep 22, 2017 5:06 am

Re: Count based on previous column value

Post by s.wieczorek »

I've solved it by adding another view to mongo that is returning grouped results
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Count based on previous column value

Post by Alex K. »

Hello

Ok.
Please let us know if you need any additional help.

Thank you.
Post Reply