Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

control the display of monthly vs daily data

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

3 REPLIES 3
ccakjcrx
Resolver I
Resolver I

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?

Anonymous
Not applicable

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 NoCreate dateModify DateBid Due datecitystate
1234562014-12-31T17:00:00.0002013-10-19T00:02:27.9742015-08-05T12:18:44.120Kew GardensNY
8763112014-02-11T08:00:00.0002010-23-09T00:02:27.9742013-11-01T15:58:04.133SeattleWA
76156242015-11-09T00:02:27.9742017-11-09T00:02:27.9742019-08-09T00:02:27.974 BostonMA
      
      
instance   
Proj NoAcc NoDelivery Date   
761562475740502017-11-09T00:02:39.823   
87631176156242017-11-09T00:02:27.974   

 

Anonymous
Not applicable

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.