Skip to main content
New Participant
May 15, 2024 3:37 PM UTC
Question

Column chart to be displayed using record centric

a!columnChartField(
label: "2012 Tempo Usage Trends",
categories: {"2012", "Qt 2", "Qt 3", "Qt 4"},
series: {
a!chartSeries(label: "IT", data: {9, 4, 3, 2}),
a!chartSeries(label: "Human Services", data: {8, 3, 2, 1}),
a!chartSeries(label: "Sales", data: {12, 6, 4, 2}),
a!chartSeries(label: "Marketing", data: {15, 7, 3, 5})
},
colorScheme: "SUNSET",
xAxisTitle: "Quarter",
yAxisTitle: "% Active",
showLegend: true
)

Can we get this column graph with record centric feature

    3 replies

    peter.lewis
    Employee
    May 15, 2024 3:49 PM UTC

    Sure, it's pretty straightforward - your primary grouping would be Quarter, the secondary grouping would be the Department, and the measure would represent whatever your data is using. Have you seen this page? docs.appian.com/.../Chart_Configuration_Using_Records.html ?

    And if you're having issues, can you tell us what you have tried and what isn't working?

    New Participant
    May 15, 2024 4:03 PM UTC

    Hi Peter,

    Thanks for quick response we need graph with yearly and quarterly data (2012, Q1, Q2,Q3) should be a mix graph to be displayed and also interval : quarter is not provided by default as well and above is the representation to be attained

    peter.lewis
    Employee
    May 15, 2024 5:30 PM UTC

    For something like that, you might want to try creating a custom record field. Basically, you could add logic that would add a new field that represents your dates, so you can bucket a date value either in 2012, or Q1, Q2, etc.

    That being said, if it's really custom calculations, there's no reason the configuration you have above won't work - the goal of records-powered charts is just to make it easy to configure a lot of basic reports.