Unable to display the column name in column chart

Hi,

Am unable to display the column name in the column chart below is the screen shot for the same.

Am able to click on the column bar but unable to get the column name as i have around 150 columns in the chart .

expecting the column name in orange line.

Can anyone suggest me pls.

Thanks in advance

  Discussion posts and replies are publicly visible

  • 0
    Certified Senior Developer

    Hello

    Could you please share your code? Or any data that you feel that was used to construct this chart. It would help us understand the issue.

  • Hi,

    Below is the code.

    a!cardLayout(
    contents: {
    a!columnChartField(
    /*label:"Countries And Part Numbers",*/
    data: 'recordType!{82e5a5fc-9888-4df5-8f27-4f1900b91983}TMP_TyrecountriesDetail',
    config: a!columnChartConfig(
    primaryGrouping: a!grouping(
    field: 'recordType!{82e5a5fc-9888-4df5-8f27-4f1900b91983}TMP_TyrecountriesDetail.relationships.{21a8b5db-5035-4f48-b585-87c9381375d8}countriesrecord.fields.{252faf70-b103-4c62-90ea-0a3b5aa93918}country',
    alias: "country_primaryGrouping"
    ),
    measures: {
    a!measure(
    function: "COUNT",
    field: 'recordType!{82e5a5fc-9888-4df5-8f27-4f1900b91983}TMP_TyrecountriesDetail.fields.{cc708611-a802-4471-8782-0040fec61b11}partNumber',
    filters: a!queryFilter(
    field: 'recordType!{82e5a5fc-9888-4df5-8f27-4f1900b91983}TMP_TyrecountriesDetail.fields.{2dcd2e09-75f6-4768-a9d7-036c93c5f777}isactive',
    operator: "=",
    value: true
    ),
    alias: "partNumber"
    )/*a!measure(*/
    /*function: "COUNT",*/
    /*field: 'recordType!{82e5a5fc-9888-4df5-8f27-4f1900b91983}TMP_TyrecountriesDetail'.fields,*/
    /*filters: a!queryFilter(*/
    /*field: 'recordType!{82e5a5fc-9888-4df5-8f27-4f1900b91983}TMP_TyrecountriesDetail.fields.{2dcd2e09-75f6-4768-a9d7-036c93c5f777}isactive',*/
    /*operator: "=",*/
    /*value: true*/
    /*),*/
    /*alias: "partNumber"*/
    /*)*/

    },
    dataLimit: 150,
    link: a!dynamicLink(
    value: fv!selection,
    saveInto: local!selection
    )
    ),
    label: "Countries And Part Numbers",
    xAxisTitle: "countries",
    yAxisTitle: "Part Number",
    stacking: "NONE",
    showLegend: true,
    showDataLabels: false,
    showTooltips: true,
    labelPosition: "ABOVE",
    allowImageDownload: true,
    colorScheme: a!colorSchemeCustom(
    colors: {
    "#ea9999"/*"#00a88f",*/
    /*"#0087ac",*/
    /*"#005faa",*/
    /*"#323b81"*/

    }
    ),
    height: "MEDIUM",
    xAxisStyle: "STANDARD",
    yAxisStyle: "STANDARD",
    refreshAlways: false,
    refreshOnReferencedVarChange: true,
    refreshAfter: "RECORD_ACTION"
    )
    },
    height: "TALL_PLUS",
    marginAbove: "STANDARD",
    marginBelow: "STANDARD",
    showBorder: false,
    showShadow: true
    )

  • 0
    Certified Senior Developer

     : It seems that when there are many columns, the column names cannot adjust properly with the columns themselves. However, when the number of columns is reduced, the names can adjust accordingly. I attempted to address this by modifying the code, but encountered the same issue as you did.

    a!columnChartField(
    label: "Most Tasks",
    categories: {
    "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug",
    "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug",
    "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug",
    "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug",
    "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug",
    "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug",
    "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug",
    "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug",
    "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug",
    "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug",
    "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug",
    "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug",
    "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug",
    "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug",
    "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug",
    },
    series: {
    a!chartSeries(label: "Tasks", data: {
    34, 30, 30, 27, 24, 19, 18, 16,
    34, 30, 30, 27, 24, 19, 18, 16,
    34, 30, 30, 27, 24, 19, 18, 16,
    34, 30, 30, 27, 24, 19, 18, 16,
    34, 30, 30, 27, 24, 19, 18, 16,
    34, 30, 30, 27, 24, 19, 18, 16,
    34, 30, 30, 27, 24, 19, 18, 16,
    34, 30, 30, 27, 24, 19, 18, 16,
    34, 30, 30, 27, 24, 19, 18, 16,
    34, 30, 30, 27, 24, 19, 18, 16,

    })
    },
    yAxisTitle: "Tasks",
    showLegend: false,
    showTooltips: true

  • 0
    Certified Senior Developer

     It seems that when there are many columns, the column names cannot adjust properly with the columns themselves. However, when the number of columns is reduced, the names can adjust accordingly. I attempted to address this by modifying the code, but encountered the same issue as you did.