hi, i have a pivot_table that i’d like to plot with DataTable but can’t seem to get the result i want. I am currently just using the default dt.DataTable (rows=[{}]) component and this is only showing the results of the columns that are not the index. Attached is an image of what the data looks like when printed to console
is it possible to create a pivoted data table with dash dt.DataTable?
i’ve pivoted the data by doing the following:
data = pd.pivot_table(data, index=['projects.title', 'object_codes.object_code'], aggfunc=np.sum) which is why budget_items.budget is currently the only column showing, i guess since projects.title and object_codes.object_code are now indices i’m not sure how to get the callback to render these in the table
thank you