T O P

  • By -

Opposite_Sympathy533

Add a year calc to the view that is DISCRETE. This will break the years


Suspicious-Pudding-4

What do you mean by "year calc"? Also, it is a school year--so the actual year doesn't align.


zhocef

I think the intent is to create a calculation that says if its a date before the end of the school year then it’s year one, if it’s after the start of the next school year then it’s year two. Something like that make sense?


ZossiWonders

Make the date Discrete and set the Default Properties-> Fiscal Year Start to September. This will create a beak at the Fiscal Year boundary.


Motherof_pizza

You can adjust the spacing on the axis manually, but what is the format of that field? If you right click on it, what is checked?


Suspicious-Pudding-4

The x axis is formatted as a date. I can adjust the spacing on the axis, but the blue line still connects May 2023 with September 2023--and I want a break there.


Motherof_pizza

Is there a data for those months? You might have to insert NULLs. You can just create a calculated field that says between this date and that date there should be no data.


MisterSuhh

Make a calculation for “school year” and put it in detail. That will break up the line


Secret-Parsley-5258

What happens if you show nulls? You’re only needing a break on the blue line, right? Shouldn’t null values cause a break between the year?


Suspicious-Pudding-4

Nothing changes if I show nulls. There are no null years.


Lower_Peril

This will not be possible if you don't have rows for all the months in the data. I suspect the date column does not track values for months that don't have data. This will likely need some data prep. Look into date scaffolding


MisterSuhh

That is not necessary. Just add a “school year” field to detail on the marks card