Usage History page - Filter problem

[softech]

I saw couple members talked about the filter on Usage History and I seem to remember I didn't see all entries earlier, too. So I did an experiment. 

Turn out , it is true, the filter Usage History page does not work 100%

The filter on  Usage History page does not work if you filter by type right a way and apply the filter

For example, I tried to filter from Jun 1 to today (July 20) with Data only, 

 Click apply filter

 I will see only one page of data, from ONLY July 19 to July 12

What I need to do :

1. change the custom date to what I want (jun 1 to today) but Type keep it to ALL

2. Then run through pages after pages to make sure the result got to Jun 1, In my case 34 pages of usage

3. then I can go back and change the filter Type to Data using the same date range

4. now I will get what I want, a data only result from Jun 1 to today, 5 pages only

And, If I did not go from Page  1 to  Page 34 earlier, let say I stopped at Jun 20, then Data filter result will be only  from Jun 20 to today

A better way without doing all these:

 Just download the Excel file (xlsx) and filter it yourself with your local Excel.  

Filter and Download does not mean it only download the filtered data and type.  The download will download all 90 days regardless what you try to filter on the site

@J_PM , sorry, need you to bring it back to the development for a quick fix

[DUGGS]

So I download the excel worksheet of my usage. And I get only 2 days instead of everything. it did it normally last month but this month. Not so much

[dust2dust]

There are also plentiful excel viewer programs (apps) available.

[popping]

In addition to @softech info, if you do not have Microsoft Office, you can read the usage history xlsx file.  You can use the Google Sheets to read it, sort it.

1.  Open the Google Sheets, upload the usage history xlsx file to Google.

2.  Import the xlsx file.

3.  You can sort/delete to eliminate the history you are not interested.

[softech]

Morning @J_PM 

just want to confirm if PM is aware of the minor problem on Usage history regarding the filter?  Look like more members are noticing problem with it (except not everyone aware of the workarounds)

thanks

[nrg_svr]

Yeah, I've downloaded the supposed to be handy Excel file, except it does not show time specifically, just a date, and so in trying to figure out why I have a data problem, I can't get any specifics other than a date... And by the way this is way too much work to be doing on a mobile device while you're on holiday and your data has been cut off and your account summary for usage still shows that you have data! Anyway thanks for this post it's helpful to a certain degree

[CountyDownIeUk]

---

@softech wrote:

@CountyDownIeUk   Windows.  

The Usage History download is xslx but the Payment History page is pdf

I don't think there is anywhere to change the download type.  Weird they have different one. 

I wonder if they considered Safari browser, whether from iPhone or iMac, as a mobile and hence showing the mobile site, so just using PDF.  I notice some screenshots on iMac are using Mobile version of the site and not the desktop mode

---

Ok thanks. And.....weird.....is to be expected I guess. 

[softech]

@CountyDownIeUk   Windows.  

The Usage History download is xslx but the Payment History page is pdf

I don't think there is anywhere to change the download type.  Weird they have different one. 

I wonder if they considered Safari browser, whether from iPhone or iMac, as a mobile and hence showing the mobile site, so just using PDF.  I notice some screenshots on iMac are using Mobile version of the site and not the desktop mode

[CountyDownIeUk]

Thanks. What kind of operating system are you using?

When I did transactions on my iMac it just went to a pdf.....no choice. 

[softech]

@CountyDownIeUk   actually the download is to XSLX, which is very useful for filtering if you have excel

Just that many users will likely stay with checking on the web without downloading.  And I just worry some users are filtering by just one month (like checking data usage), seeing 2 weeks worth of  info and thinking they didn't use that much and PM miscalculated their usage, which in fact, just the filter didn't return the complete result

[CountyDownIeUk]

@softech 

Once you download to a pdf file...have you tried to copy and paste into excel?

OR did you copy and paste from the 5 pages of screens?

I did with my transactions....to PDF and then copy and paste from the PDF but had to use the text to cell command with ; delimiter. Iam curios on your next step into excel. And only if the files were the way they used to be!!! Then do all the sorts you like in excel!! OR if PM could allow a choice of download like CSV  or text file vs PDF.