Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Each day i have transactions like Pass & Fail. I have Daily data. I want to show each customer Fail transactions in Hours. Please suggest me
Thanks
Hello!
Do you have some sample qvw with data?
Hi
Try like this
Load *, Hours(DailyDate) As Hours, If(transactions = 'Fail', 1, 0) AS Flag yourTableName;
In Front end,
Hours - Dimension
Count({<Flag = {1} >} Customers)