Hi,
I have fetched the data from Salesforce, I want to show month-wise leads count.
For example, I want to show January 2021 has this many leads, February has this many and march has this many. Also, Suggest me the best component where this data should be fit.
Hi,
You can group your results by month. Depending on your visualization, you can set the display output for your dates to be Month, or Month and Year - whatever makes sense for your data. When you group by month, you'll have the option to COUNT the results in your Column A to show the number of IDs. You can also use COUNTDISTINCT to count only the unique leads.
The types of component you use is up to you. Do your users like a chart? Or a table?
Thanks!
Hey @Meggan King,
Thank you for your help.