comparison charts
i have a chartt working nicely. it shows all check ins to our three offices. what i would like to do is have the chart show all three offices on a different line. 
 [[36%20pm]](https://community.wappler.io/uploads/default/original/3x/b/9/b9894868d0f071b68133c362e9eddbf8c2ceb98f.png "screen shot 2019-11-28 at 12.41.36 pm.png")
how would i divide it up into three different lines?
as i had the time, thought i would tidy things up, just one custom query needed, no view required. just change the office names and copy/paste into a custom query 
have a great christmas party! 
select sum(office1) as office1,sum(office2) as office2,sum(office3) as office3,hours from 
((select 
cou…
?answer :
step 1 of 1 :


in a pareto chart, the bars are always arranged in descending order according to frequencies.
the pareto chart helps us understand data by drawing attention to the more important categories, which have the highest frequencies. [@raja](/u/raja)

this could inspire you:

[[image]](https://aws1.discourse-cdn.com/business6/uploads/dynamobim/original/3x/9/b/9bcef06d0c489d0ac566fe7dad2328002f964445.png "detail-lines-by-offset.png")

here, i recreate lines by offsetting the room finish boundaries, but any other method to select the needed curves could work as well… you should have three choices.

 thanks for the update...i'll check it out. Hi,  

  

check the following Code  

SQLCopy Code

```
-- Question 1 Answer
SELECT E.EmployeeID,E.Day, (E.TotalTime/60) 'TotalHours', (E.TotalTime%60) 'Minites'
FROM (SELECT EmployeeID,CONVERT(VARCHAR(10),FromTime,102) 'Day',SUM(DATEDIFF(mi,FromTime,ToTime)) 'TotalTime'
      FROM tblEmployeeTimeCard
      GROUP BY EmployeeID,CONVERT(VARCHAR(10),FromTime,102))E

-- Question 1&2 Answer
SELECT E.EmployeeID,E.Day, (E.TotalTime/60) 'TotalHours', (E.TotalTime%60) 'Minites',
CASE WHEN (E.TotalTime/60)>=6 THEN E.TotalTime - (30* ROUND((E.TotalTime/60*6),1))
     ELSE (E.TotalTime/60) END 'TotalWorkHours'
FROM (SELECT EmployeeID,CONVERT(VARCHAR(10),FromTime,102) 'Day',SUM(DATEDIFF(mi,FromTime,ToTime)) 'TotalTime'
      FROM tblEmployeeTimeCard
      GROUP BY EmployeeID,CONVERT(VARCHAR(10),FromTime,102))E
```
  

  

For ur Question 2, I am not getting. give some more details about that. if possible send some sample data. if access over lap like (From date is 2013 -04-05 11:55:00PM to 2013-04-05 19:10:00PM)  

then we can't able to fine the time difference. So check the code for Question No 1 and give the feedback.  

  

Regards,  

GVPrabu hey, so after some minor improvements i finally found the time to make this into a doc that everyone can use, adopt and copy. let me know what you think and if you have any improvements.

[image]

[life dashboard - the all in one tracker](https://coda.io/@heuschkelsimon/life-dashboard-all-in-one-tracker)

track your personal habits, finances, tasks and time … hi @jcarneiro!great question. if your goals were from a previous quarter, you’ll need to change your view from ‘current quarter’ to the quarter in which those goals were listed.the ‘current quarter’ view should show you all goals (regardless of status) in the current quarter, as well as any other incomplete goals from previous quarters. completed goals from previous quarters can only be viewed in that quarter.here’s a screenshot in case this helps:let us know if you have any other questions! thanks! hi david, thank you for question. these are called alerts, and show payments that have come into and out of your account. the cards you see should be dragged and dropped on the slideby grid in the row for that particular customer or supplier (it doesn't matter which date, as slideby will automatically move this to the correct incoming/outgoing payment date). please visit this page to learn more about alerts and how these can be matched to any invoices and estimates you have created. 1) form controls use a list box for the names of the conference rooms;use datetimepicker for scheduling the reservation...set the format property to custom;set the customformat property to mm dd yyyy hh mm ssof course, will also need ok button2) dataset up the data file like this:room date time1st floor, 6/8/21, 14:00:002nd floor, 6/9/21, 10:00:003rd floor, 6/8/21, 13:30:00reads these records from the file to determine if there is a conflict.if the room is available at the requested time, writes the reservation tothe file (in append mode) and displays a message box saying the reservationis complete. otherwise display a message box saying the room is unavailableat that time. re: help<br><br>you need to get the documents scanned in and sent through to our offices. hi@thebatswhiskersjust checking in on your half hourly usage issue?i think you’re also effected by the situation outlined in this topic, where i confirm:please be advised that there is a known issue effecting some customers, where half hourly usage information is not populating ontoonline usage graphs, despite good smart meter comms, and a populated monthly chart.if you haven’t already, we’d appreciated it if you could make oursupport teamaware of this, so a ‘case’ can be raised, helping us to identify the volumes of those effected.