Chart show blank for a column that combines two date columns

[d-grigsby]

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?

[WillowMobileSys]

Not all labels are shown by design.  Otherwise, for charts with lots of plot points, like yours, the X-axis labels would all overlap and become unreadable.  The unfortunate thing is that we have no way to control it.  

[d-grigsby]

I think I was not being specific enough.  My apologies.  It actually says "blank" in the chart which takes up just as much space as the actual date.  Also I have two types of dates, sales and receipts and the label "blanks" are only sales dates.  Only receipt have the actual dates.  If what was stated above was the case wouldn't the date label just not show up?

[WillowMobileSys]

---

@d-grigsby wrote:

If what was stated above was the case wouldn't the date label just not show up?

---

I guess not.  It appears that AppSheet has chosen to explicitly show [blank] as the label value for a Date column used as the X-Axis label where no date has been set.

Understanding your true issue now, I think the problem you are facing is in combining different types of data that don't necessarily make sense with each other - e.g. Sales and receipt dates as opposed to an Equipment count Date.

The chart implies it is showing an Equipment count and with a Date as the X-axis label, it seems you should ALWAYS have a definitive date of when the Equipment count was obtained.  If you don't have another column that would always provide that definitive date,  maybe one needs to be added in addition to the one you are using??

[d-grigsby]

I do have a date column that combines the dates (sales and receipts) into one column which I believe is a definitive date. I actually have two and tried both (see original post).  When in a table view the dates pull through with no problems.