Forum Discussion
AdministratorMake graph MONTH/HOUR
Hello
I have a table where I want to see the documents entered according to their exact time. The database has a now () columa to which you drag into a new column only the time (and recognizes it as Time format). On the other hand I have the months of this income.
I would like to be able to make some kind of graph of lines, points (such as the scattering), but between Month vs Hour (x, y respectively), and q in the values to be calculated just go making a continuous line q counting or showing each data.
Is this possible to perform? Something like xD?
I have the data and it is interpreted correctly. I attach a sample in CSV, which attaches the Year, Month, Time and the code of the document.
| Year | My | Hour | Code |
| 2018 | January | 7:13:57 | 201824014740100000 |
| 2018 | February | 7:21:10 | 201827117830100000 |
| 2018 | March | 7:31:12 | 201827217980300000 |
| 2018 | April | 7:32:33 | 201826117200100000 |
| 2018 | May | 7:33:27 | 201827217980300000 |
| 2018 | June | 7:34:11 | 201827217980301000 |
| 2018 | July | 7:35:43 | 201824315182700000 |
| 2018 | January | 7:35:52 | 201824315182500000 |
| 2018 | January | 7:36:11 | 201827217980300000 |
I need to make the graph Month vs Hour, filtered with year and make a count of the codes according to Month / hour.
Thank you very much geniuses!
1 Reply
Hi Syndicate_Admin ,
You may consider creating two new columns in Power Query Editor to convert [HOURS], [MY] to NUMBER type respectively.= Number.Round(Time.Hour([Hour])+Time.Minute([Hour])/60+Time.Second([Hour])/3600,6)And then new a scatter visual:
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
