Excel Replacement Dashboard
<%= form_with url: dashboard_path, method: :get, local: true do |f| %>
<%= f.label :category, "Select Category:" %>
<%= f.select :category, options_for_select(@available_categories, params[:category]), include_blank: "All Categories" %>
<%= f.label :region, "Select Region:" %>
<%= f.select :region, options_for_select(@available_regions, params[:region]), include_blank: "All Regions" %>
<%= f.submit "Filter Data" %>
<% end %>
Dashboard Results
| Column 1 |
Column 2 |
Value |
<% @records.each do |record| %>
| <%= record.category_column %> |
<%= record.region_column %> |
<%= record.metric_value_column %> |
<% end %>