Say I wanted to create a table with the fields State, City, City Count, and Total. If I try to use |stats values(city) as city, count by State
I get a chart that only lists cities, but does not give their individual total, only the total for State.
Is it possible to get my chart to look like this:
| STATE | CITY | city_count| Total |
|CA | San Jose | 5 | 15 |
| | Santa Clara | 10 | |