Forum Discussion
GRedhead
4 years agoHelper I
Group Columns in Stacked Column Chart
Hi, Does anyone know how I can group the following columns? If I look at the data in a table I see the same Year and Qtr the same Case Type and want to sum the cases. But for some reason, I cannot...
- 4 years ago
Hi, i think we have worked it out, it appears to be because of the sort on the Year & Qtr column, it was on the month sort order but when we switch it to itself the column displays as I expected, a bit weird.
Shishir22
4 years agoSolution Sage
Hello GRedhead ,
Can you please check data. There might be blanks or spaces or NULL or "" but all looks similar.
You can use Len(), ISBLANK() functions to rectify.
Please mark it as answer if it solves your issue. Kudos are also appreciated.
Cheers,
Shishir
GRedhead
4 years agoHelper I
Sorry not sure I understand the above, all 3 lines have values please see my screenshot and the data on the left.