Dashboard Chart

Greg H. shared this question 14 months ago
Answered

I set up a dashboard chart using 2/20 to 2/24 as my test time period

this dashboard is to show fees collected in data table

fdb0e5095dfe6bed13e055bd16d70435

i am using my report discounts and fees

89d87ce6f31ec416acf6419e6cd3af80

and my filter of

9167903a1685af25619d9c66c978b222


first the orders have no discounts but the dashboard shows 71.38

then it shows delivery 71.38 but delivery is 114.31

it shows DW (we just switched over to ADW) of 54.75 which is correct

and shows ADW of 16.63 but the real number is 53.03


now the funny thing is if you take chart numbers of the dw and the adw and add them together you get 71.38 agian meaning everyone of the fees are 71.38 which we all know is impossible


something is wrong in the math first but also in what is pulling from the leads into the report


any help would be great

Comments (2)

photo
1

Try "lead $ Fee Price" in place of "lead $ Fee"

photo
1

I switched and still got wrong totals

The only one correct is DW

photo
1

I have developers looking into this will provide update when we have one.

Thanks!

photo
1

I just ran a test with how you have it now...matched up the last 30 days with the Accidental damage waiver. Both matched with $466.64. So it's working with the "Lead $ Fee"

photo
photo
1

has there been any movement on this producing the wrong numbers?

Leave a Comment
 
Attach a file