i have a data like this . I will attach data also
now from that data i want to show that in the past 10 races, the teams who have low Pen will win the races
Data: LOAD Year, [Race Result], Year&chr(10)&Pen as Key, Laps, Pen, Score FROM [Book1 (1).xlsx] (ooxml, embedded labels, table is Sheet1);
Create bar chart with Dimension Key and below expression
Below are the bar graph settings
Here is the bar chart
@capriconuser can you also share the expected output ?
in load Script or in UI ?
i.e. for each year, e.g. 2010, the 10 lowest values or the lowest value of 2010?
@capriconuser Maye be like this :
Data: LOAD Year, [Race Result], Laps, Pen, Score FROM [.\Book1(1).xlsx] (ooxml, embedded labels, table is Sheet1); Tmp: noconcatenate First 10 load * resident Data order by Pen DESC; drop table Data;
Create straight table with Dimension Year and Pen
Sort the Pen dimension (Promote it to Top). Go to chart properties-> Sort -> Numeric-> Descending
Go to chart properties->Presentation and check the below option
@Kushal_Chawda i tried but this works only for table whereas when i try to convert this table into Pie or Bart chart and put Min(Pen) in expression then this shows incorrect data.