GeoffBarrenger
Qrew Captain
Joined 5 years ago
User Profile
User Widgets
Contributions
Percentage and Totals of a Stacked Bar
We're tracking our productivity through actions taken during the week. Each week has a total of actions taken, a sum of both the blue and red portions of the below chart. The Blue actions were scheduled - ie: we knew and planned ahead. The red actions were last minute urgent requests that came in. These are unfortunately unavoidable - but we'd like to keep this number in the 5-7% range. Is there anyway in a stacked bar to show the percentages of the series as they relate to their summary? I'd also like to see a total of the stacked bar. I'm not sure if this is possible with some sort of summary formula, but would be very helpful!Get a value from another entry in the same table
We've been using a QB Table to track snap shots of business health. Once a week we log some numbers across different tables. This isnt exactly what we do - but as an example it could be: how many orders placed how many orders delivered how many orders on hold how many customers outstanding on payment how much billed received how many customer feedback received etc etc and we do this for each "store" - let's assume we have 2 stores. Now here is my issue! I want to track PERCENTAGE CHANGE since last week. So it's the same table - but I want to compare, "orders placed" this week for this store, versus "orders placed" last week for the same store. I want to be a formula for a field which would show PERCENTAGE INCREASE OR DECREASE. ( and then we can get fancy and make charts, graphs, color code etc) Where I am having the issue is - how do I find the value of last weeks entry for this store?? let's assume each entry has a "week of" and a "store code" - so for example: 07-05-2024 and MAINSTORE. How do I get the # of orders placed for 07-28-2024 and MAINSTORE and have it auto populate? I would prefer to go this route where I can lookup last weeks #'s - so if I ever need to scale I can. Worst case is that I will choose 2-3 KPIs to log each week. Any ideas?Calculation which requires Summary from Other Table
Hi all I'm trying to calculate a total cost per unit shipped of both Overhead Expenses and Operating Expenses so that I can benchmark a KPI for my services. I am having trouble summarizing totals from another table. Operating Expenses are easy - we track based on jobs and log expenses. This can include gas, contractors, extra rentals, food expenses, etc Overhead Expenses - I am struggling with because my per unit Overhead expense should get lower and lower the more units I ship, but will also go up the more days into the Fiscal Year I am in. This requires me to solve for how many days into the Fiscal Year have passed (no issue), and also to summarize how many units I have shipped this fiscal from another table (my problem) How do I put into a formula, a request to summarize the total from a different table using a parameter? ex: var number totalUnitsShippedThisYear = <look in table unit shipped and get total # of units shipped who's ship date = this fiscal year> Below is the step by step how I am thinking this through! Currently what I do is pull a summary report, and then hard code the total number of units shipped. This makes it fairly easy to pull the report once a week - but I would like this to be automated. Thank you thank you! ----------------------- Below is the thinking! Divide number of days in a year into my Yearly Overhead Expenses(a number I provide) estimate (rent, salary, fixed costs) to find my Daily Overhead Expenses (how much it costs just to keep the business going) I can calculate number of days into this fiscal we are currently (days Since April 1) I can then multiply the number of days passed this year by the Daily Overhead Expense. I now know how much I have spent to keep the building open this year. example: if it costs me $365,000 to keep the building running, and I am 15 days into the year (April 15th) I have spent $15,000 Then what I need to do is summarize from another table my total shipped units. The thinking is - if I am shipping more units, my total Overhead Expense PER UNIT will be lower ( the building still costs money to rent if I ship 1 unit per year or 1 million units per year) If I can get the summary of units shipped this Fiscal Year(from another table), I can now divide the Daily Overhead Expense by the Total Shipped Units this Fiscal Year I would now have my PER UNIT Overhead Expense scenario 1: If it is April 15th, and I know it has cost me $15,000 to keep the lights on, but I have only shipped 1 unit, my Per Unit Overhead Expense is $15,000!!! scenario 2: But if we have been busy and shipped 1000 units a day since April 1, out Per Unit Overhead Expense is only $1 For each unit shipped - I will also have an PER UNIT Operating Cost (which I already can calculate) - based off how many units were shipping in that job (another table) and the expenses from that job (ex: we bought gas for the truck and paid for the driver of the truck by mile) scenario 1: The 1 unit I shipped cost me $100 of gas. The operating cost per unit is $100 scenario 2: every day I made one delivery of 1000 each - and somehow magically the gas was always $100 (to keep math simple for this - but we would use actuals($0.10 per unit) I want to now add by PER UNIT Operating Cost & PER UNIT Daily Overhead Expense to find my TOTAL COST PER UNIT scenario 1: thinking back to scenario 1, my Total Cost per Unit is actually $15,100 scenario 2: thinking back to scenario 1, my Total Cost per Unit is $1 plus 10 cents, so $1.10 per unit.Re: Convert a Connected Table to Normal Table
Hi ben_simon thanks for finding this message!! I can't! Still getting the same replies. I tried in incognito to try to remove potential cache issues. When trying to post, I get the "cannot add message" and then if I try again I get the "content not published". Appreciate you looking into this!Re: API_DoQuery Response Different in Web vs Terminal AppToken/UserToken
Hi - Just in case anyone else searches and finds this, figured it out: curl -X POST 'https://domain/db/table' -H 'Content-Type: application/xml' -H 'Content-Length:' -H 'QUICKBASE-ACTION: API_DoQuery' -d ' <qdbapi> <usertoken>xxxxxxxxxxxxxxxx</usertoken> <query>{6.CT.1427445}AND{99.EX.TRUE}</query> <clist>74.104.52</clist> <slist>98</slist> </qdbapi>' The XML format doesn't return correctly in terminal - but if you pass it as xml you can get the desired result. I still don't know why the URL version doesn't work as well - probably a formatting or quotations issue, but this turned out great. ------------------------------ Geoff Barrenger ------------------------------API_DoQuery Response Different in Web vs Terminal AppToken/UserToken
Hi, Having trouble getting a DoQuery result to work with curl in terminal. Trying to do this way to then parse out for what I actually need. End goal is: 1) user scans a QR code with a client 2) client sends the QR code to QuickBase 3) QuickBase returns with an image URL corresponding to that QR code 4) client displays the image to the user When I do the call in the web browser with apptoken, I get the expected result (needs to be logged in). When I do the call in terminal with usertoken, I get a response but the response doesn't have any data in the response. Any ideas? (I also noticed I needed to use %27 instead of quotes in the web browser) I am searching field 6 to see if "1427445" is contained in that field and field 6 contains "alternate10" expected response is the file name and the URL Interestingly, when I did an API_Authenticate, and then tried in terminal with apptoken and ticket, I still got the same result!!! Web Browser: https://domain.quickbase.com/db/table?a=API_DoQuery&apptoken=xxxxxxxxxxxxxxxxxxxxx&includeRids=1&query={%276%27.CT.%271427445%27}AND{%276%27.CT.%27alternate10%27}&clist={26.6.52} Result ( This works ): <qdbapi> <action>API_DoQuery</action> <errcode>0</errcode> <errtext>No error</errtext> <dbinfo> <name>Assets</name> <desc>Assets available in AEM / ASC.</desc> </dbinfo> <variables> </variables> <chdbids> </chdbids> <record rid="1158942"> <filename>s7-1427445_alternate10.psd</filename> <social_url>RESPONDS WITH THE URL TO AN ASSET WHICH I NEED SUCCESSFULLY</social_url> <update_id>1631916573812</update_id> </record> </qdbapi> Terminal: curl "https://domain.quickbase.com/db/table?a=API_DoQuery&usertoken=xxxxxxxxxxxxxx&includeRids=1&query={'6'.CT.'1427445'}AND{'6'.CT.'alternate10'}&clist={26.6.52}" Response ( does not work ): <?xml version="1.0" ?> <qdbapi> <action>API_DoQuery</action> <errcode>0</errcode> <errtext>No error</errtext> <dbinfo> <name>Assets</name> <desc>Assets available in AEM / ASC.</desc> </dbinfo> <variables> </variables> <chdbids> </chdbids> </qdbapi> ------------------------------ Geoff Barrenger ------------------------------
