
Specialist
2019-07-19
08:01 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
data model question example
Hello All,
I have two file excels like this , I need to count the number of project managed by younger Manager (there is 5 in our example )
Thanks for your help
838 Views
5 Replies

MVP
2019-07-19
08:19 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Several options are there, I would do it like:
And then UI expression: Count({<Flag={'Younger'}>} [Project Name])
829 Views

Specialist
2019-07-19
08:48 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you for your help but it didn't work for me ,
I think there is no association in the two table
821 Views

MVP
2019-07-19
08:55 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You would not require the younger manager table/field once you create the Flag field in the main table. You can just drop that table.
818 Views

Specialist
2019-07-19
08:58 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please try the kpi with Count({<Flag={'Younger'}>} [Project Name])
and you will see that doesn't work 🙂
Thanks
813 Views

MVP
2019-07-19
09:01 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It works with me. Try to share your sample app where it doesn't work.
811 Views
