AndrewJudd

Graph of sales per supplier

Discussion created by AndrewJudd on Jan 28, 2017
Latest reply on Jan 28, 2017 by philmodjunk

hi all, I'm trying to build a chart to display totals sold per artist in the current year.

 

I have a tables as below -

 

ARTWORKS (inventory) = INVOICE LINE ITEMS = INVOICES

 

as normal

 

then I have (as attached)

 

HOME (where charts are displayed in a slide control) = INVOICES LINE ITEMS | CHART (based on primary key and an unstored calculation of the invoice date from invoices to a gdate field that auto enters the year from get current year (as attached). The graph appears empty unless the c_Invoice_Year is turned into a text or number field and the numbers are added.

 

Can charts not work off unstored calculations?

 

Do this mean scripting an invoice date directly into the line items field every time an item is added and also if the invoice date is changed?

 

Thanks!

 

 

Screen Shot 2017-01-28 at 13.04.44.png

Outcomes