Hello, another user was able to help me with the formula but I am still working on the graph.
formula test123 it counts how many times a provider submits a case, then it segments it into how many cases they submit per year. The system recognizes as a submitted case when there is a date in FirstSetupApprovedDate.
Note that a provider can be in the data several times so I dont know if I should add Distinct function
CASE when `FirstSetupApprovedDate` IS NOT NULL then
(CASE
WHEN COUNT(`Provider`) >= -1 AND COUNT(`Provider`) <= 10 then 'Povider 1-10'
WHEN COUNT(`Provider`) >= 11 AND COUNT(`Provider`) <= 20 then 'Povider 11-20'
WHEN COUNT(`Provider`) >= 21 AND COUNT(`Provider`) <= 50 then 'Povider 21-50'
WHEN COUNT(`Provider`) >= 51 AND COUNT(`Provider`) <= 80 then 'Povider 51-80'
WHEN COUNT(`Provider`) >= 81 AND COUNT(`Provider`) <= 150 then 'Povider 81-150'
WHEN COUNT(`Provider`) >= 151 AND COUNT(`Provider`) <= 400 then 'Povider 151-400'
WHEN COUNT(`Provider`) >= 401 AND COUNT(`Provider`) <= 50000 then 'Povider 400+'
end)
END
I am using a BAR . FirstSetupApprovedDate as X axis and then Y axis the formula above and ideally i would like to see a bar for each segment.
