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.