Count based on previous column value
-
- Posts: 19
- Joined: Fri Sep 22, 2017 5:06 am
Count based on previous column value
Hi,
How can i do distinct count based on a value from a previous column?
How can i do distinct count based on a value from a previous column?
- Attachments
-
- screen_grouping.jpg (15.61 KiB) Viewed 2877 times
Re: Count based on previous column value
Hello.
There is a CountDistinct function that you could use.
Thank you.
There is a CountDistinct function that you could use.
Thank you.
-
- Posts: 19
- Joined: Fri Sep 22, 2017 5:06 am
Re: Count based on previous column value
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
Hello.
Please, send us your report template with sample data.
We need to reproduce the issue to give you more detailed answer.
Thank you.
Please, send us your report template with sample data.
We need to reproduce the issue to give you more detailed answer.
Thank you.
-
- Posts: 19
- Joined: Fri Sep 22, 2017 5:06 am
Re: Count based on previous column value
I've solved it by adding another view to mongo that is returning grouped results
Re: Count based on previous column value
Hello
Ok.
Please let us know if you need any additional help.
Thank you.
Ok.
Please let us know if you need any additional help.
Thank you.