Dashboard Style Reporting

[AdamH]

I'd like to get my head around some basic reporting within the PowerApp I'm building.

The App itself is a staff database around staff development.

I have some fields within the PowerApp that I would like to have a Dashboard style page report on.

The first two being:

Each staff record has an 'Active' drop down field that has Yes / No option. My first two would be How many Active Staff do we have & How many Inactive staff do we have and report back a figure like the picture below.

When a user selects; for example, 'Total Active Staff', I want this to navigate to a new window & gallery to show those results. 

Thanks 🙂

oh and a shout out to @WarrenBelz for taking the time out of his evening and helping me solve a problem that was sending me to an early grave!  

[AdamH]

@RandyHayes 

The error I get on the Dashboard Screen is:

Also:

and the error I get on Dashboardreport1 is:

[RandyHayes]

@AdamH 

Ah, so you are using the same variable in other places with dissimilar record schemas.  Where else are you trying to set glbCurrentRecord?  It should ONLY be set on the DashBoard Gallery OnSelect.

[AdamH]

@RandyHayes 

I have fixed:

Set(glbCurrentRecord,ThisItem);Navigate(DashboardReport1)

&

glbCurrentRecord.Items

& added the little bonus you gave me of: glbCurrentRecord.Title & " Report"

The only problem that still exists is that my current Detail Screen and Edit Screen use BrowseGallery1 which was the original app gallery made by PowerApps. 

When I navigate from Dashboard to Dashboard Report Gallery and then from there to use the original Detail and Edit screens?

[RandyHayes]

@AdamH 

Yes, so those editforms should have an Item property based on the Gallery you are selecting from - your Dashboard Report Gallery.  
I believe that was Gallery2 - so, Gallery2.Selected

[AdamH]

@RandyHayes 

Currently the Detail and Edit form have the Item of BrowseGallery1.Selected which is the original gallery. 

Is there a way of having BrowseGallery1 and Gallery2 . selected??

[AdamH]

@WarrenBelz 

Inviting you for comment on my last post. Your views would be appreciated

[WarrenBelz]

@AdamH ,

Not much I can add to @RandyHayes 's already detailed contribution.

[RandyHayes]

@AdamH 

I explained that it would be set to the glbCurrentRecord variable. You would only be setting this variable with the same record type as your datasource and then your Detail and Edit form would use that variable on the Item property.

Is there any issue with getting that to work?

[AdamH]

@RandyHayes 

I've sent you a quick message.