Calculate sales in Feb 29th

[Asmaa-elsheikh]

Hi All,

I was trying to visulaize sales in the previous months, but the numbers of feb is missing some values of the feb 29th & add the values to march, although I just add the date & the sales to the line chart with no extra calculation only implicit values

Is there any explanation

[Asmaa-elsheikh]

I have tried it many times in different periods, but still the same 

[MVenables]

Hi,

Just checking as it was a Leap Year this year so 29th Feb should be showing up. Do you have a current Year Flag filtered to TRUE? What kind of Calendar is it? just a basic one?

[Asmaa-elsheikh]

@MVenables thanks for replying 
I am working with very basic data calendar all date related to 2024 

actually the chart did not ignore all data in 29th feb, but there is some missing values & I donlt know why 
"Do you have a current Year Flag filtered to TRUE? No, I did not, should I ?

[MVenables]

OK, no you won't need a calendar flag in that case. As it has some data but not all from 29th Feb. It may depend where your datasource has come from or that it hasn't come through properly in Transform data. Is it direct from a SQL server, Excel document or something else?

[Asmaa-elsheikh]

it's from a google spreedsheet 

[MVenables]

Ok, might be a silly question but have you tried refreshing the data to see if it just needs pulling through? you can do this as per below, right click the table and go onto Refresh Data. See if this helps first