Page 1 of 1

Count based on previous column value

Posted: Wed Oct 18, 2017 1:13 pm
by s.wieczorek
Hi,
How can i do distinct count based on a value from a previous column?

Re: Count based on previous column value

Posted: Wed Oct 18, 2017 6:00 pm
by HighAley
Hello.

There is a CountDistinct function that you could use.

Thank you.

Re: Count based on previous column value

Posted: Thu Oct 19, 2017 5:40 am
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

Re: Count based on previous column value

Posted: Thu Oct 19, 2017 6:18 pm
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.

Re: Count based on previous column value

Posted: Fri Oct 20, 2017 7:10 am
by s.wieczorek
I've solved it by adding another view to mongo that is returning grouped results

Re: Count based on previous column value

Posted: Sat Oct 21, 2017 9:35 am
by Alex K.
Hello

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

Thank you.