DataUp Member

Comments

  • This will give you the dominator CASE WHEN DAYNAME(`Date`) = 'Sunday' THEN COUNT(DISTINCT CONCAT(`Date`,DAYNAME(`Date`))) WHEN DAYNAME(`Date`) = 'Monday' THEN COUNT(DISTINCT CONCAT(`Date`,DAYNAME(`Date`))) WHEN DAYNAME(`Date`) = 'Tuesday' THEN COUNT(DISTINCT CONCAT(`Date`,DAYNAME(`Date`))) WHEN DAYNAME(`Date`) =…
    in Count the number of times one day appears in a month Comment by DataUp November 2021
Default Avatar