Forum Discussion
Export Underlying Data not exporting everything
- Hi there
If the filter is showing you the same output, then that would be why it is not exporting what you expect.
I would suggest making sure that the filter shows the same way you want it to be exported.
Hi,
I have 2 filters applied to this visual. One of the filters is dollar amount greater than $3000, and the other one is a binary field. It seems that when I remove the filter for the dollar amount, March 2019 data present when I export it. However, even if I have the filter on, March 2019 data is in the visual. I don't know if it makes sense or not but if it appears in the visual, shouldn't it appear in the dataset when I export as well?
Hi
This might be caused by filter in report, you could see below images, it will export data which apply filter
You could refer to Export data from visualizations for details.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Hi there
If the filter is showing you the same output, then that would be why it is not exporting what you expect.
I would suggest making sure that the filter shows the same way you want it to be exported. Hi
I understand that, but the thing that I don't understand is that since the filter is applied to the visual, e.g. filtering Dollar more than $3000, which means that anything more than $3000 will be included in the visual. However, March 2019 does not appear in the underlying export file eventhough it is in the visual, which does not make sense since whatever is showing in the visual should appear in the underlying export file.
Daren
- Hi Daren,
That makes total sense as it is not exporting what you are viewing.
If you hover of the Filter button, does it indicate to you what is filtering the visual? Hi Gilbert,
Yes it is showing me what I filtered out.
Thanks for the tips, GilbertQ !
- No worries, glad to help you!