Table Card Total Rows Incorrect

Reply
Major Blue Belt

Re: Table Card Total Rows Incorrect

The total row is just completing whichever calculation you give it on an aggregate level. So when you have sum(staffing_level) / count(distinct ifnull(empID,1)), your total row is doing 4+4+4+6+6+6+2 = 32 / 7 = 4.57.


**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.
Highlighted
Major Blue Belt

Re: Table Card Total Rows Incorrect

This is why in one of my first posts I mentioned you may want to create an "All Corporate" department, which has the totals already calculated. You can then put together a table like the attached image using MAX(staffing_level) and MAX(no_employees) as your two fields.

 

Hope this helps,

 

Brian


**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.
Major Blue Belt

Re: Table Card Total Rows Incorrect

It is important that the totals remain calculated on the fly due to PDP policies and applying card filters.  I was able to create the card with the correct totals and the drill down functionality by editing my dataflow to stage the data differently so I could sum all of the fields.

 

Thank you all for the feedback and ideas.  I love to use the Dojo as a sounding board when I get stuck!

Chris
Dojo Admin

Re: Table Card Total Rows Incorrect

@cwolman,

 

Can you make the replies that best helped you by clicking on Accept as Solution so others can benefit from this thread.

 

Love the collaboration! NIce work @Property_Ninja and @ST_-Superman-_!

 

Regards,

Dani aka "Mr.Dojo"

Dojo Admin
**Say "Thanks" by clicking the "heart" in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"
**You can update your Dojo Community name and avatar by clicking on your avatar then the "My Profile" button.
Major Blue Belt

Re: Table Card Total Rows Incorrect

I marked solutions by both @Property_Ninja and @ST_-Superman-_ as they both helped me in arriving at the final solution. 

 

Thanks again.

Chris
Dojo Admin

Re: Table Card Total Rows Incorrect

Thank you!

Dani aka "Mr.Dojo"

Dojo Admin
**Say "Thanks" by clicking the "heart" in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"
**You can update your Dojo Community name and avatar by clicking on your avatar then the "My Profile" button.
Announcements
Looking for the latest Community solutions? Please visit our accepted solutions board here!