Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I want to sum all of the values only in last weekend. Infact I want to know the total number of patients came for their appointments in last week in particular specialty . e.g the table also attached an excel sheet
I want to display value only for weekending 06/09/2020 (6th September 202) as 130 for Cardiology where type is FollowUp
I want to display value only for weekending 06/09/2020 (6th September 202) as 42 for Dental where type is FollowUp
but not the values for weekending 30/08/2020
Please also review the attachments for data file and chart I want to display
WeekEnding | Type | Hospital Name | Specialty | Appointments |
06/09/2020 | FollowUp | Hospital One | Cardiology | 40 |
06/09/2020 | FollowUp | Hospital One | Cardiology | 70 |
06/09/2020 | FollowUp | Hospital Two | Cardiology | 20 |
06/09/2020 | FollowUp | Hospital Two | Dental | 30 |
06/09/2020 | FollowUp | Hospital One | Dental | 8 |
06/09/2020 | FollowUp | Hospital Two | Dental | 4 |
30/08/2020 | New | Hospital One | A & E | 4 |
30/08/2020 | New | Hospital One | A & E | 6 |
30/08/2020 | New | Hospital One | A & E | 7 |
30/08/2020 | New | Hospital One | Gastro | 9 |
30/08/2020 | New | Hospital One | Gastro | 100 |
Regards
Waqas SHah
@waqasshah Try below. Create table with Dimension WeekEnding and Specialty and below expression
=sum({<Type={'FollowUp'},WeekEnding={"$(=date(max(WeekEnding)))"}>}Appointments)
What would likely be most helpful is if you attach your QVW, so folks can review data model etc...
Regards,
Brett
@waqasshah Try below. Create table with Dimension WeekEnding and Specialty and below expression
=sum({<Type={'FollowUp'},WeekEnding={"$(=date(max(WeekEnding)))"}>}Appointments)
Thanks for your reply. Unfortunately I am getting zero value. any change required in date format? Can you please upload your QV file ? Please display it as Tabular bar .
What would likely be most helpful is if you attach your QVW, so folks can review data model etc...
Regards,
Brett