Separate values in stacked bars

[pranaynanda]

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

[woodcock]

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

[pranaynanda]

Apologies. But that did not work. It returned with the same values.