Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello Community,
I have loaded 4 csv(1 is current date file, 3 is historical files) and these contains projects start date and proj no etc and i have appended all the four csv files and get latest date records only and i have loaded one more csv that contains projectno, account number and account name.
Now i have got 1 more csv file that contains project no, account no, project delivery date. I have to use this file to control the display of monthly vs daily data.
Please help me.
Thanks,
Paruchuri
Hey @Anonymous
Is there any way you can give me an idea as to what you might want to graph, and what display/visual you had in mind? With the information provided, the best thing I can come up with is using a table to display project & account numbers, along with associated dates.
Any time dates are involved, I lean toward bar/line visuals as those are good at illustrating changes in values over time; however, you didn't mention anything related to either sales or anything like that. Are you just trying to illustrate the number of projects that have the same delivery date? Similarly, would you want to see the number of projects that had the same start date?
Hi ccakjcrx,
Thanks for your reply. when ever the associated account number logged in and opened his report then he has to see the mentioned delivery date data only.
Projects | |||||
Proj No | Create date | Modify Date | Bid Due date | city | state |
123456 | 2014-12-31T17:00:00.000 | 2013-10-19T00:02:27.974 | 2015-08-05T12:18:44.120 | Kew Gardens | NY |
876311 | 2014-02-11T08:00:00.000 | 2010-23-09T00:02:27.974 | 2013-11-01T15:58:04.133 | Seattle | WA |
7615624 | 2015-11-09T00:02:27.974 | 2017-11-09T00:02:27.974 | 2019-08-09T00:02:27.974 | Boston | MA |
instance | |||||
Proj No | Acc No | Delivery Date | |||
7615624 | 7574050 | 2017-11-09T00:02:39.823 | |||
876311 | 7615624 | 2017-11-09T00:02:27.974 |
Hello Community,
I have loaded 4 csv(1 is current date file, 3 is historical files) and these contains projects start date and proj no etc and i have appended all the four csv files and get latest date records only and i have loaded one more csv that contains projectno, account number and account name.
Now i have got 1 more csv file that contains project no, account no, project delivery date. I have to use this file to control the display of monthly vs daily data.
Please help me.
Thanks,
Paruchuri
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |