Support both humanized and raw values in the exported csv

[shankari]

• If people just want to scroll through the values, we want the humanized text
• if people want to perform their own analysis offline, we want the raw values, especially for time

I have a comment indicating this in one of my commits https://github.com/e-mission/op-admin-dashboard/commit/e0b368d790757a5cd5cc30e921b744058c408bfa#diff-1c6b8e6d103286796ce21a8276c4a4d8b258e29d6b9cc6df516a92accf4674d1R78

but I don't see it addressed in the follow-on code

[shankari]

@achasmita will work on this

[achasmita]

I started working on it but I still cannot figure out how to display both humanized and raw data. One of the option I see is:

• adding subtab or buttons - that way user can switch between humanized value and raw value easily and can export the format they prefer.
• Or we can just add columns with raw data on same table.

[achasmita]

I initially attempted to implement subtabs for displaying humanized and raw value in the table. However it is like repeating same table twice. I further explored alternative solutions and found hidden column option:

• We can initially hide the raw value column while displaying table
• User can use dropdown to dynamically select and display raw value columns.
• This way user can both display and export raw value

[shankari]

That sounds like a promising option. Do you have a link for the "hidden column" option and/or screenshots of what it might look like?

[achasmita]

I tried with some random data, here's what it looks like:

[achasmita]

That sounds like a promising option. Do you have a link for the "hidden column" option and/or screenshots of what it might look like?

https://community.plotly.com/t/how-do-i-hide-a-column-of-a-data-table-from-being-displayed-but-use-that-column-for-filtering-and-sorting/67777/2