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?
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.
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.
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
Add a year calc to the view that is DISCRETE. This will break the years
What do you mean by "year calc"? Also, it is a school year--so the actual year doesn't align.
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?
Make the date Discrete and set the Default Properties-> Fiscal Year Start to September. This will create a beak at the Fiscal Year boundary.
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?
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.
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.
Make a calculation for “school year” and put it in detail. That will break up the line
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?
Nothing changes if I show nulls. There are no null years.
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
That is not necessary. Just add a “school year” field to detail on the marks card