How can I still have a separation between 'xls' and 'xlsx' in the bar that says 'Excel'?
eval ExtTyp = case(extension="doc" OR extension="docx", "Word", extension="xls" OR extension="xlsx", "Excel", extension="ppt" OR extension="pptx", "PowerPoint", extension="hpg" OR extension="hpgl", "HPGL") | stats count by ExtTyp
Like this:
eval ExtTyp = case(extension="doc" OR extension="docx", "Word", extension="xls" OR extension="xlsx", "Excel", extension="ppt" OR extension="pptx", "PowerPoint", extension="hpg" OR extension="hpgl", "HPGL")
| eval ExtType=case(extension="xls", "Excel(xls)", extension="xlsx", "Excel(xlsx)", true(), ExtType)
| stats count BY ExtTyp
Apologies. But that did not work. It returned with the same values.