LinkedIn
Twitter
I have a chart view that shows the number of units going in and out of our inventory. The in and out are on different tables and so I made a tab in the google sheet that combines the info from both tables using a query function that brings in the key of each table into one row and the date of the transaction into the second row (only two columns). In appsheet I use virtual columns to bring all the info from each table using the key references. I then made a chart to show our schedule of upcoming sales and upcoming inventory receipts. For some reason, the sales dates are showing blank on the x-axis even though in a table view all the dates are showing. I tried using virtual columns that bring in the dates and then combining them using an if statement ("If(isnotblank([Equip Date]),[Equip Date],[Order Date])"), but I get the same results on the chart. Any suggestions as to why not all the dates are coming through on the chart?
