analytics icon indicating copy to clipboard operation
analytics copied to clipboard

Thousand separator/locale settings

Open valetrine opened this issue 1 year ago • 9 comments

Do analytics had locale settings? Or it just follow nextcloud/server locale? I had a problem for displaying date too from spreadsheet, it looked like this: image Do this just a problem from MS excel?

Thank you

valetrine avatar Jan 04 '24 09:01 valetrine

Hi, there is a logic to recognize the format based on the number of almost any format. what is the number in excel?

Rello avatar Jan 04 '24 09:01 Rello

Yeah, now that you mention it, it's Indonesian format. Thanks for clearing this.

Do you had solution for the thousand separator? I want to change it from comma to dot.

valetrine avatar Jan 04 '24 09:01 valetrine

do you have a screenshot or so? I am searching to make the setup working for everything if possible

Rello avatar Jan 04 '24 11:01 Rello

Here's some example I got:

Screenshot 2024-01-04 185605

Screenshot 2024-01-04 185709

Screenshot 2024-01-04 185846

valetrine avatar Jan 04 '24 12:01 valetrine

I need to know the source. because the Analytics logic will analyze the number coming from the backend and try to understand it

Rello avatar Jan 04 '24 12:01 Rello

Here's the sample data

Data.xlsx

valetrine avatar Jan 04 '24 14:01 valetrine

I apologize for asking OOT, but is notification severity only available in stored data? I couldn't locate it in my spreadsheet threshold, but I can find it when creating a report from stored data.

valetrine avatar Jan 05 '24 02:01 valetrine

I apologize for asking OOT, but is notification severity only available in stored data? I couldn't locate it in my spreadsheet threshold, but I can find it when creating a report from stored data.

Hello, yes, it is. because the thresholds are validated once the data is processed. if a realtime data source is used, the data is not regularly accessed. but you could load the spreadsheet data into a stored report, can´t you?

Rello avatar Feb 26 '24 10:02 Rello

Hello,

with my current version, everything seems to be correct. the table display is being adopted right now so it will look good for the next release.

...just for the data I need to see if I can do anything here... Bildschirmfoto 2024-02-26 um 11 52 37

Rello avatar Feb 26 '24 10:02 Rello