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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
juancmr1
New Member

Modeling and present info on charts

Hi,

 

I have test measurement data from a product and I would like to present in a line chart with the average amount of failed products perd day. For example a pass product should have Measurement 1 > 0.01

 

In dayly log files( with arround 72000 units tested per day)  I have the  information in the following way (1-pass/ 0-fail)

Date                    Time                 Product id        Measurement 1     Pass/fail
26/03/2019      00:17:04         6EEC9                0.0108                            1

Since I have dayly files with the test information of  a whole month, I would like to present the dayly average or percentage  of failed units. I dont know how to arrange  or model my data to be able of present a line chart plot (x-axis-date in days 1-30 and y-axis average or % of failed units)

 

I understand tha in some way I should modify the data  measurement in tables so I can estimate the failed % per day.

1.But I wonder if someone can help me to suggest how to moddel my data??

2.Should I create an additonal table with the  pass % result of each day ??  I wonder if there is an easier way since I require to update the information with new data of everyday.

 

 

thank you in advance

0 REPLIES 0

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.