Hi, I am trying to calculate the currentvsprevious Quarter sales means if I select date 3/1/2019 it is 1st march that is Q1 of 2019 year.It should display the comparison of sales for t...
...year. For completed years, that would be "December selected year" vs. "December prev. year" - no problem. But for the current year, we need the last completed month (NOT the current month!) vs. t...
...ser selects a month from filter panel, that month's values and previous month's values to be shown at the same table row. Desired result is like that; I'm sharing very very basic of my data and q...
...rderDate.autoCalendar={Year}>}Sales) Now I'm having trouble doing it for the previous year total sales KPI that I want to put next to the first one. How do I do it? Thanks in advance.
hi, I want to show current week and previous week bar in bar chart I wrote the following expression Current Week : sum({$<Date={'>=$(=Date(WeekStart(Max(Date)),'DD/MM/YYYY'))&l...
Hello, I am trying to create a sheet to display difference between previous month and current month data amounts. So far I have tried to get amount difference for current month but no luck. I...
Hi! I want to compare Current Month Value vsPrevious Month Value. I made a question 2 days ago for a Current Month vsPrevious Month Total Tickets : Get how many tickets were generated in the m...
Hello everyone, In my dashboard, I have two KPI's which shows data for current month and previous month. I have to show the sales data based on month selection for entire month till date. S...
...o compare the Id's row by row for April vs March.(compare April as latest and March as old data)
Scenario 1 : Id 1 related Stage value is same in April and March so the value should be "Match"
S...
...otal Amount for daily : 0.00% Total Amount for monthly : 0.00% Total Amount for MTD Vs LMTD : 0.00% Total Amount for currentVsprevious month: 0.00% Kindly help me o...
