Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Problem with scatter chart

Hello guys,

I have problems with my scatter chart. Here it is: Screenshot_2.png

There is an obvious difference in the amounts.

Here are my formulas:

DIMENSIONS

- Vendor

=if(vNSMonth>0 and vNSWeek=0,

(if(aggr(Count(DISTINCT Invoice_V),Year,Month,Vendor_Name)>=vNSMonth,Vendor_Name)),

if(vNSMonth=0 and vNSWeek>0,

(if(aggr(Count(DISTINCT Invoice_V),Year,Month,Week,Vendor_Name)>=vNSWeek,Vendor_Name))

))

EXPRESSIONS

- Net Amount(X axis): Sum ([NetAmount_V])

- Purchase count(Y axis😞 count (Distinct [Invoice_V])

- Net Amount(Z axis😞 Sum ([NetAmount_V])


Thanks,

Todor

0 Replies