Forum Discussion

GRedhead's avatar
GRedhead
Icon for Helper I rankHelper I
4 years ago
Solved

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...
Need Help
  • GRedhead's avatar
    GRedhead
    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's avatar
Shishir22
Icon for Solution Sage rankSolution Sage
4 years ago

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's avatar
    GRedhead
    Icon for Helper I rankHelper I
    4 years ago

    Sorry not sure I understand the above, all 3 lines have values please see my screenshot and the data on the left.