Comments
-
Can someone suggest a solution? Thank you.
-
I want to count the distinct service invoices I have when the category is service. I wrote my case statement in the following way (CASE when `Category` = 'service' then COUNT(DISTINCT `Invoiceno`) end ) I don't know what's wrong. Please help. This also happened in the following cases. CASE WHEN ‘promotions’ IS NOT NULL…
-
Select the properties tab and in properties bar --> general--> select the maximum number of bars to be displayed. In my case, I set it to 15 and it showed me top 15 products pushing the rest of the cases to 'others' category. caution: before doing this sort the graph by Descending. Hope this helps. Thank you.