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
Discussion posts and replies are publicly visible
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?
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
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.