Hi Team,
I have requirement to show the month and year on X-axis of column chart and created record count on Y-axis in canvas app.
Dataverse table contains account table. It contains account name, account create date.
Dataverse Data is
| Account Name |
Created Date |
| Acme Inc. |
2023-01-10 |
| GlobalTech |
2023-01-25 |
| Innovators |
2023-02-15 |
| StarTech |
2023-02-20 |
| FutureWorks |
2023-03-05 |
Added to canvas app . My requirement is show the month wise created records in column chart.
Added X-Axis = Month name, Y-Axis =Created Records Count.
Using Below code in chart items property but getting error.
AddColumns(GroupBy(AddColumns('Account Head',"MonthName",
Text(Month(['Created Date])',"[$-en-US]mmmm")),
"MonthName","MonthlyRecords"
),
"RecordCount",CountRows(MonthlyRecords)
)
but getting errors provide correct solution to my requirement.
Thanks in advance for quick response.
