G
Guest
hi
i am a beginner and I am trying to get a top 3 downtime per date for a
machine.
I copied this from another help section
In (Select Top 3 [DOWNTIME] From [5 - TREND BY CAUSE Line 2] Where
[DATE]=[SHIFT DATA ENTRY].[DATE] Order By [DOWNTIME] Desc)
but instead of giveing me report like below
300 12/7
200 12/7
50 12/7
500 11/7
450 11/7
10 11/7
It only gives me top 3 downtime regardless of date like
500 11/7
450 11/7
300 12/7
please help, thanks.
i am a beginner and I am trying to get a top 3 downtime per date for a
machine.
I copied this from another help section
In (Select Top 3 [DOWNTIME] From [5 - TREND BY CAUSE Line 2] Where
[DATE]=[SHIFT DATA ENTRY].[DATE] Order By [DOWNTIME] Desc)
but instead of giveing me report like below
300 12/7
200 12/7
50 12/7
500 11/7
450 11/7
10 11/7
It only gives me top 3 downtime regardless of date like
500 11/7
450 11/7
300 12/7
please help, thanks.