Category
Data Sources
Product Version
9.0
Union of two views count distinct patient ID
On Hold
This is easily done using a custom query but I am trying to use tables for better performance (hopefully). First view has patientID and date and same with second view. when I put them together I get duplicate years and distinct count for each year.
Example:
2022 5,280
2022 38,555
I need a distinct count of the patientID for the whole year between both views for 2022.
The only way that I can think of that I have not tried is creating a third NULL view using that as the first view and join the two other views upon it. But They have to be aggregated as I have 200,000+ records for patientIDs and would like to run for 3 years prior to current year to current YTD.
Any ideas are welcome.
Brian Smith
The same question
Hi Brian,
Thanks for reaching out to Yellowfin support.
Could you please let us know the exact version and build of Yellowfin you are currently using it would be great if you can provide the info.jsp page?
It would be great if you can share the screen recording of the process you are doing and upload it into our ftp server?
https://ftp.yellowfin.bi/files/
Regards,
Sri Vamsi
Hi Brian,
Thanks for reaching out to Yellowfin support.
Could you please let us know the exact version and build of Yellowfin you are currently using it would be great if you can provide the info.jsp page?
It would be great if you can share the screen recording of the process you are doing and upload it into our ftp server?
https://ftp.yellowfin.bi/files/
Regards,
Sri Vamsi
Hi Brian,
Greetings for the Day!
We would like to check, with you if you had the opportunity to read our last response.
Request, you to review and let us know if you have any questions or further assistance is required.
Regards
Sri Vamsi
Hi Brian,
Greetings for the Day!
We would like to check, with you if you had the opportunity to read our last response.
Request, you to review and let us know if you have any questions or further assistance is required.
Regards
Sri Vamsi
Sri,
Before I upload items I have talked to our team here and we see no way to be able to do a distinct count from two data sources utilizing 2 views in a union in yellowfin as it aggregates distinct counts for each view before applying the union.
So if I could get this question asked: Is it possible to do a distinct count using a union from 2 different data sources (2 views)?
If this is possible I will gladly upload the required items/files.
Thanks for your assistance.
--Brian
Sri,
Before I upload items I have talked to our team here and we see no way to be able to do a distinct count from two data sources utilizing 2 views in a union in yellowfin as it aggregates distinct counts for each view before applying the union.
So if I could get this question asked: Is it possible to do a distinct count using a union from 2 different data sources (2 views)?
If this is possible I will gladly upload the required items/files.
Thanks for your assistance.
--Brian
Hi Brian,
Thanks for your response.
Please allow me sometime, I'll check with our wider team and get back to you as soon as possible.
Regards,
Sri Vamsi
Hi Brian,
Thanks for your response.
Please allow me sometime, I'll check with our wider team and get back to you as soon as possible.
Regards,
Sri Vamsi
Hi Brian,
Greetings of the Day!
Could you please let me know your available time to connect with you and discuss on this issue further. I'll be available in between Mon-Fri 9 PM IST to 6AM IST.
Regards,
Sri Vamsi
Hi Brian,
Greetings of the Day!
Could you please let me know your available time to connect with you and discuss on this issue further. I'll be available in between Mon-Fri 9 PM IST to 6AM IST.
Regards,
Sri Vamsi
Sri,
Tomorrow, Friday June 16th, 11 AM CST which is 9PM IST if I did my math right, I will be available.
Thank you,
Brian Smith
Sri,
Tomorrow, Friday June 16th, 11 AM CST which is 9PM IST if I did my math right, I will be available.
Thank you,
Brian Smith
Hi Brain,
Thanks for your response.
We can connect on the meeting link that I have shared in previous ticket(27754) and we can discuss on both the issues.
Teams Meeting
Regards,
Sri Vamsi
Hi Brain,
Thanks for your response.
We can connect on the meeting link that I have shared in previous ticket(27754) and we can discuss on both the issues.
Teams Meeting
Regards,
Sri Vamsi
Sri,
I am shorthanded again today. Monday or Tuesday will work for me. Let me know.
Thanks, have a great weekend.
Brian
Sri,
I am shorthanded again today. Monday or Tuesday will work for me. Let me know.
Thanks, have a great weekend.
Brian
HI Brian,
Sure, we can schedule this meeting on Monday 11 AM CST which is 9PM IST. Please join the link below.
Teams Meeting
Regards,
Sri Vamsi
HI Brian,
Sure, we can schedule this meeting on Monday 11 AM CST which is 9PM IST. Please join the link below.
Teams Meeting
Regards,
Sri Vamsi
Hi Brian,
Could you please join the call? Let me know if you want me to reschedule this meeting.
Regards,
Sri Vamsi
Hi Brian,
Could you please join the call? Let me know if you want me to reschedule this meeting.
Regards,
Sri Vamsi
Hi Brian,
I have raised a Jira task to our product team on behalf of you. I'll let you know once I received an updated from them.
Regards,
Sri Vamsi
Hi Brian,
I have raised a Jira task to our product team on behalf of you. I'll let you know once I received an updated from them.
Regards,
Sri Vamsi
Replies have been locked on this page!