[Charts] - View count per day in chart

[PoorReymark]

Hello Caspio team,

I want to make a chart with viewcount in trendline and date/time on the bottom of the chart. Is this achievable? If yes , how can I display the date ranging from 1-31 (depends on month ex. if feb 1-28). TIA!


Example is the image below.

[Volomeister]

Hello @PoorReymark

To build such chart, first you need to have a table that will store dates and the respective number of view counts. The table will look something like this:




Based on this table, you can set up Line chart where:

1. You use a separate field for each series



X Axis will be Date field with custom formatting to display only day part of the mm/dd/yyyy 



Value for Y axis will be set to sum of views



The end result will look something like this:

[PoorReymark]

Awesome! Thanks for the detailed explanation!