Custom fields - Analytics about metamagik HOT 15 CLOSED

between work, play, wife, and kids...I'll look into it. I make no promises.

from metamagik.

from metamagik.

Exactly what I thought was going on, was going on. I didn't account for 2 things:

1.) Your timezone
2.) Time of the day.

I have corrected the code, to now, account for your timezone, and extend the full day on the to field. The from field will now account for timezone, but will continue to start at 00:00 hour of the day, since that is when the day begins.

Previously, if I chose today in my to field, which today is 2/9/2021, the unix timestamp was:

with corrected code, the new timestamp is:

I'm still 59 seconds off, but oh well, who makes tasks in the last 59 seconds of a day anyway....

from metamagik.

i missed a commit, should be set now

I just remade the 1.4.11 release, https://github.com/creecros/MetaMagik/releases/tag/1.4.11, not going to tick it up to 1.4.12.

from metamagik.

is your question in reference to, MetaMagik, in its current form?

or, are you just simply asking me if this is possible?

Currently, no, I have not implemented such a thing. But, yes, it is possible.

from metamagik.

I have to admit that such a feature would make work much easier, so if such a report is possible, would you consider implementing it in your plugin?

from metamagik.

@korlikiangel

is the criteria, of "Type" being a number, or just look at all the field values and determine if they are numeric?

i have this working, by just looking at all the values and using is_numeric as the condition, which will include all numeric values, including values from custom dropdowns. But I could just limit it to Custom fields with the "Type" defined as "Number".

I did not do a date range filter, as of yet, already spent more time than I wanted...did you really need the range?

from metamagik.

The more I think about it, I think it should be based on the data type being a number.

i.e. Number has to be chosen in the Custom field settings:

otherwise, there could be foreseeable issues...

from metamagik.

@korlikiangel

Master Repo has been updated, test it out, let me know what you think (you will need to install via the master repo files).
https://github.com/creecros/MetaMagik/archive/master.zip

I'll wait for your feedback before making a new release.

from metamagik.

added one with a date range for creation dates as well, as requested.

from metamagik.

Wow, I didn't expect you to do this so fast, thank you very much for implementing this solution, I also think that numerical values will be the best solution for these reports. While testing I noticed only one thing, in the report where there is an option to select a date range, we have to select the creation date from any date to a date in the future, it does not display the results if we select to today or to yesterday.

from metamagik.

For example, no statistics are displayed if I select dates only for yesterday, or any other single day or range up to yesterday. If I select a range from earlier days to today it works. if I select statistics only for today it does not display the statistics either. However, the statistics for today will be displayed if I select dates from today to tomorrow.

from metamagik.

I already moved on to a new plugin I was working on, so might be a bit before I can get back to this one.

what I may need to do, is convert both back to dates, drop the times, convert back to Unix time, then add however many seconds in a day to the to date....
it sounds like today, is not necessary today in comparison to the creation time, since in reality, it's in Unix time, so even 1 sec difference would classify as tomorrow, for example.

from metamagik.

Hi,

Thank you very much for making the changes, I updated the plugin and the first "Custom field total distribution for open tasks" works, but if I try to access the second tab "Custom field total distribution with date range" I get this message, Internal Error: SQL Error: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type bigint: ""

I am using postgres as database

from metamagik.

Works like a dream, thanks for your help and commitment.

from metamagik.