Column Chart

manjit.1486

Certified Senior Developer

7 months ago

Hello,

Can anyone help me in this:

How to hide these categories text(Qt1, Qt2, Qt3, Qt4) from column chart?

Also, numbers/range(0-100) from y axis column?

Note: For this column chart configuration, I am using records.

Thanks

Discussion posts and replies are publicly visible

Parents

0 Abhishek Karumuru
Certified Senior Developer
7 months ago

Hi manjit.1486 You can use

xAxisStyle (Text): Determines how to display the labels and axis separators for the X-Axis. Valid values: "STANDARD" (default), "NONE".

yAxisStyle (Text): Determines how to display the labels, axis separators, and grid lines for the Y-Axis. Valid values: "STANDARD" (default), "MINIMAL", "NONE".

to hide these data lables
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel
0 manjit.1486
Certified Senior Developer
7 months ago in reply to Abhishek Karumuru

Okay, thanks. Actually only yAxisStyle and xAxisStyle wasn't working before. Rest is working fine.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 manjit.1486
Certified Senior Developer
7 months ago in reply to manjit.1486

HI Abhishek Karumuru
Could you please tell me how to hide or remove this 0 data labels from column chart?

This is basically shows zero records of categories. Please suggest..
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 manjit.1486
Certified Senior Developer
7 months ago in reply to manjit.1486

Hi Abhishek Karumuru and Mathieu Drouin can you please suggest?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Stefan Helzle
Certified Lead Developer
7 months ago in reply to manjit.1486

I think you will have to remove these values from the underlying data. It might be possible that you need to query the data separately and feed it into the chart manually.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

0 manjit.1486

Certified Senior Developer

7 months ago in reply to Stefan Helzle

a!localVariables(
  local!data1:a!queryEntity(
    entity: cons!INN_DSE_CASE,
    query: a!query(
      aggregation: a!queryAggregation(
        {
          {
            a!queryAggregationColumn(field: "status", isGrouping: true()),
            a!queryAggregationColumn(
              field: "stage",
              isGrouping: false,
              aggregationFunction: "COUNT",
              alias: "count"
            ),
          }

        }
      ),
      paginginfo: a!pagingInfo(1, - 1),     
    )
  ),

      a!columnChartField(
        label: "Column Chart",
        categories: {"a","b","c"},
        series: a!forEach(
          items: local!data1,
          expression: a!chartSeries(label: "Chart", data: fv!item.status)
        ),
        stacking: "NONE",
        showLegend: true,
        showTooltips: true,
        labelPosition: "ABOVE",
        colorScheme: "RAINFOREST",
        height: "MEDIUM",
        xAxisStyle: "NONE",
        yAxisStyle: "NONE"
      )
  
)

I tried to use query for column chart. But it didn't work as expected. That's why I used records for this. But only this zero thing need to figured out. Thanks. Let me again check in query.
Stefan Helzle can you look at this query?

Reply

0 manjit.1486

Certified Senior Developer

7 months ago in reply to Stefan Helzle

a!localVariables(
  local!data1:a!queryEntity(
    entity: cons!INN_DSE_CASE,
    query: a!query(
      aggregation: a!queryAggregation(
        {
          {
            a!queryAggregationColumn(field: "status", isGrouping: true()),
            a!queryAggregationColumn(
              field: "stage",
              isGrouping: false,
              aggregationFunction: "COUNT",
              alias: "count"
            ),
          }

        }
      ),
      paginginfo: a!pagingInfo(1, - 1),     
    )
  ),

      a!columnChartField(
        label: "Column Chart",
        categories: {"a","b","c"},
        series: a!forEach(
          items: local!data1,
          expression: a!chartSeries(label: "Chart", data: fv!item.status)
        ),
        stacking: "NONE",
        showLegend: true,
        showTooltips: true,
        labelPosition: "ABOVE",
        colorScheme: "RAINFOREST",
        height: "MEDIUM",
        xAxisStyle: "NONE",
        yAxisStyle: "NONE"
      )
  
)

Children

No Data