Displaying Data from Google sheets Query.
Hello all. Leads Management App. I’ve got my app working perfectly. Now I’m creating a dash board to show some “Pivotal” tables for reporting, such as Quarterly, daily averages, etc.
My data source is Google sheets, so I normally just do a bunch of google queries to display the data in the way that I want.
I’ve created a sheet for each table, so that the tables are clearly defined and added the table to my app. Now one of them is working perfectly fine, but I noticed some weird behavior on one of the tables. It seems its reading the bottom row as the column headers instead of the top row. I’v regenerated it a few times, but keep getting the same result.
Attached pic of actual data source and how it was generated in appsheet.
Any ideas?
Hi Have you tried making your top row of headers bold so appsheet knows where the headers are? Check this article out https://help.appsheet.com/data/data-the-essentials
And if that doesn’t help, instead of using number use month names.
UPDATE. I think it was because the column headers were numbers. I was
originally Month number (for the purpose of sorting).
I changed it to a string “01 - Jan”, “02 - Feb” etc. and its working now.
@Aleksi_Alkio Yup just figured it out thnks!
May I ask where do you need that order?
User | Count |
---|---|
39 | |
25 | |
22 | |
20 | |
15 |