Hello
I have a table
I want this
I am not sure which tool (chart, table anything else) and arguments would be best to explore and learn in order to get the result I want.
Do you have any advice?
Thank you.
Assuming you can split your project names with underscores (and that you really meant A_2/a_2 etc)
| eval project_number=mvindex(split(project,"_"),1)
| eventstats values(project) as project by project_number
| fields - project_number
| eval project=mvjoin(project,"/")
| stats list(*) as * by project
| foreach category*
[| eval <<FIELD>>=mvjoin(<<FIELD>>,"/")]
Could you provide more details on the logic here?
Assuming you can split your project names with underscores (and that you really meant A_2/a_2 etc)
| eval project_number=mvindex(split(project,"_"),1)
| eventstats values(project) as project by project_number
| fields - project_number
| eval project=mvjoin(project,"/")
| stats list(*) as * by project
| foreach category*
[| eval <<FIELD>>=mvjoin(<<FIELD>>,"/")]