Two values for same date/year not showing in bar chart

[#1]

Hi community!

I have an excel file that has estimate and actual values and sometimes both for the same day (2014) and when I create a bar chart that year with both values is not showing at all! How can I tell, already in the load phase, to load only the latter value (6,95 in this case)? Or to tell the chart which value to use?

  Date                    Value

31.12.2016	9
31.12.2015	8,1
31.12.2014	8
31.12.2014	6,95
31.12.2013	7,54
31.12.2012	7,83
31.12.2011	8,2
31.12.2010	8,51

Thanks for your help!

Heidi

[robert_mika]

t1:

load * Inline [

Date,                    Value

31.12.2016, 9

31.12.2015 ,8,1

31.12.2014, 8

31.12.2014, 6,95

31.12.2013, 7,54

31.12.2012, 7,83

31.12.2011, 8,2

31.12.2010 ,8,51

]

;

t2:

load

Date as date,

lastValue(Value) as val

Resident t1

group by Date;

drop table t1

[awhitfield · Accepted solution]

Hi Heidi,

looks like your expression is just Value, in which case you could try changing the expression to :

FirstSortedValue(Value, Value)

Which gives

HTH Andy

[#4]

Thank you both solution worked!

-Heidi