% Load the .mat file containing the timetable
loadedData = load('matlab.mat'); % Replace with your actual .mat file path
% List the variables in the loaded data
vars = whos('-file', 'matlab.mat');
% Display the variable names
disp({vars.name});
tt = loadedData.a8data_org1; % Replace with your actual timetable variable name from the .mat file
% Apply the function to calculate the fiscal year for each time entry in the timetable
% Assuming 'time' is the name of the datetime variable in 'tt'
tt.FiscalYear = arrayfun(@(d) fiscalYear(d), tt.time);
% Assuming 'cat' is the variable in 'tt' that contains the category data
% Create a combined variable 'YearCat' as a string for fiscal year and category
tt.YearCat = strcat(string(tt.FiscalYear), "_", string(tt.cat));
% Convert 'YearCat' to unique numeric indices
[categories, ~, idx] = unique(tt.YearCat);
% Count occurrences of each unique category
counts = accumarray(idx, 1);
% Plot the counts
figure;
bar(counts);
set(gca, 'xticklabel', categories); % Set the x-axis labels to the categories
xlabel('Fiscal Year_Category');
ylabel('Count');
title('Counts by Fiscal Year and Category');
% Define the function to determine the fiscal year
function fy = fiscalYear(d)
if month(d) >= 7
fy = year(d);
else
fy = year(d) - 1;
end
end
------------------------------------------------------------------------------------------------------------------------------------------------
If you find the solution helpful and it resolves your issue, it would be greatly appreciated if you could accept the answer. Also, leaving an upvote and a comment are also wonderful ways to provide feedback.
Professional Interests
- Technical Services and Consulting
- Embedded Systems | Firmware Developement | Simulations
- Electrical and Electronics Engineering
