I have different set of tables updated on different dates
Table 1
- Location 1, Work Done %, Date A
- Location 2, Work Done %, Date A
- Location 3, Work Done %, Date A
- Location 4, Work Done %, Date A
Table 2
- Location 1, Work Done %, Date B
- Location 2, Work Done %, Date B
- Location 3, Work Done %, Date B
- Location 4, Work Done %, Date B
Table 3
- Location 1, Work Done %, Date C
- Location 2, Work Done %, Date C
- Location 3, Work Done %, Date C
- Location 4, Work Done %, Date C
I would like to see a report (chart) showing how the Work Done % at each location varies over Date A, B and C.
Instead of using the option "add to the end" (I will get 12 rows of records in one merged table) , can I maintain the 3 files seperately in an online folder and get Zoho Analytics to produce the same report?
What I wish is to achieve: user will add new file every two weeks, to show the updated Work Done % at a new date. Is it possible for Zoho Analytics to pick up the new file and update the Work Done % vs Date report every time a new file is added?