How to do a chart by days

[Johny_Freitas]

i have table with month informations and i want to separate them by days and create a chart.

i know do it separate them by month using “eomonth”, but how separete by days?

[Steve]

Can you elaborate more? I’m not sure I understand.

[Johny_Freitas]

exemple:
i want to use formula “Count” to how many problems have in that day. like this:

day 13 from august there is 3 problems:
2019-08-13 20:07:17 problem A
2019-08-13 20:07:14 problem B
2019-08-13 20:07:17 problem C

day 15 from august there is 5 problems:
2019-08-15 20:07:17 problem A
2019-08-15 20:07:14 problem B
2019-08-15 20:07:17 problem C
2019-08-15 20:07:17 problem D
2019-08-15 20:07:17 problem E

and do a chart, by month and when i click by day

[Steve]

THIS IS NOT TESTED!

1. Add a user setting column named Start Date to contain the date of the start of the report period.

   • Set Show? to ON.
   • Set Type to Date.
   • Set Initial value to one month ago today with the expression:

     (
       EOMONTH(TODAY(), -2)
       + MIN(
         LIST(
           DAY(TODAY()),
           DAY(EOMONTH(TODAY(), -1))
         )
       )
     )
     

   • Set Reset on edit? to ON.

2. Add a user setting column named End Date to contain the date of the end of the report period.

   • Set Show? to ON.
   • Set Type to Date.
   • Set Initial value to one month after the Start Date with the expression:

     (
       EOMONTH([[Start Date]], 0)
       + MIN(
         LIST(
           DAY([[Start Date]]),
           DAY(EOMONTH([[Start Date]], 1))
         )
       )
     )
     

   • Set Reset on edit? to ON.

3. Create a new worksheet to serve as the basis of the report table.

   • Name it Problem Report
   • Only one column.
   • Set the column header to Day
   • Add 31 rows with the corresponding numbers 1 to 31.
   • If you’d like to allow reports longer than one month, simply add more rows with the corresponding day numbers.

4. Create a new table in your app for the worksheet created above.

   • Set Table name to Problem Report.
   • Set Are updates allowed? to Read-Only

5. Configure the Day column of the new Problem Report table.

   • Set Type to Number.
   • Set Key to ON.

6. Add a virtual column to the Problem Report table for the Day’s date.

   • Set Column name to Date.
   • Set App formula to:

     IFS
       (
         (USERSETTINGS("Start Date") + [Day] - 1)
         < USERSETTINGS("End Date")
       ),
         (USERSETTINGS("Start Date") + [Day] - 1)
     )
     

   • Set Type to Date.

7. Add a virtual column to the Problem Report table for the list of the Day’s problems.

   • Set Column name to Problems.
   • Set App formula to:

     IFS(
       ISNOTBLANK([Date]),
         FILTER(
           "Problems",
           (
             DATE([Timestamp])
             = [_THISROW].[Date])
           )
         )
     )
     

8. Add a virtual column to the Problem Report table for the count of the Day’s problems.

   • Set Column name to Count.
   • Set App formula to:

     IFS(
       ISNOTBLANK([Date]),
         COUNT([Problems])
     )
     

   • Set Type to Number.

[Bellave_Jayaram]

@Johny_Freitas, one solution could be to setup a separate sheet using sheet formulas where the data is shaped like you want.