Hi team, I don't know why I am getting wrong totals in AwesomeTable. I have compared it against Google charts and others data visualization and all they give me the right Total. Do you have an idea about what could be happening? That is DateTime column.
2 plus ones
Shared publicly•View activity
- Hi. Please share your:
⚫ AwesomeTable link
Please share with us your AwesomeTable view & Google Sheets datasource so we can pinpoint where the problem is and provide the right solution in the soonest possible time. Detailed instruction here https://goo.gl/gDaAaP.
⚫ Google Sheets datasource
It's best to set the sharing settings to Anyone with the link - http://goo.gl/cx6nMA.
* You can opt to anonymize your content by using dummy data (fake, but realistic) if your Sheets contains confidential info.Aug 25, 2017
- Aug 28, 2017
- Randolph AbelardoModerator, please remove your email address.
I will update you here.Aug 28, 2017
- , I've done extensive testing to determine the root cause of this issue. I tried your datasheet and some of mine.
Things I've done:
1.) Made sure that the column-formatting is correct.
2.) Checked all date-entries 1 by 1 to look for typos or errors - none.
3.) Used the int() function to separate the date from your date-time format - nogo.
4.) Manually entered the dates then formatted the column as Date - nogo.
It appears that when a specific (single) date is selected, no results will be displayed. Unless the said specified (single) date is set as the minimum or maximum entry in the slider - then, it will show the correct result and count (frequency).
Recommendations / workaround (for the meantime):
1.) Instead of selecting a specific date (e.g. 6/20/2017), the date slider should span 2 days or more (for this example: min. @ 6/18/2017, max @ 6/21/12017).
Note: The date-slider's sensitivity & incremental step is dependent on the entries & range of your relevant date-column (i.e. choosing 6/19/2017 - as an example - won't work and that choosing another earlier date is the only viable option).
2.) If there are only a couple of entries, best to use the categoryFilter as this displays the correct count (frequency) of the associated items for the specified (single) date.
Let me also raise this issue to & so they can further investigate the issue and provide a solution in the soonest possible time.Aug 29, 2017
- Hireally appreciate your support on this, I will follow your recommendations, and hoping your team can fix the issue.Aug 29, 2017
- Supplementary screenshot for Recommendation # 1 above.Aug 29, 2017
- Jean-Rémi DelteilModerator+1Indeed, for now the DateFilter is behaving kind of like the NumberRangeFilter: if the 2 thumbs are against each other, then the upper bound equal the lower bound.
In this case, only result exactly equal to the limit are displayed.
This is a correct behavior for the NumberRangeFilter, but for DateFilter, it's not really useful, and more than that, it's a problem.
Note taken ! This will gets addressed in the future.Aug 30, 2017
- Randolph AbelardoModerator, I will now tag your post under Solved (Advices). An update will be given once a permanent solution is implemented. Thanks.Aug 30, 2017
Add a comment...