Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I've been working with Tableau and QlikSense both of them had possibility to automatically aggregate columns in pivot table,
is it possible to implement similar functionality in QV ?
As You can see, I use Date(create_ts) -> hour(create_ts) the problem is, that we have multiple columns pre DATE->HOUR pair,
is it possible to aggregate it to one row ?
LOAD RecNo() as ID,
* Inline
[Workflow, Folder, Session, CPU, create_Ts
Wkf1, GroupN1, F2, 130, '2011-01-01 01:01:01'
Wkf1, GroupN1, f1, 50, '2011-01-01 01:01:01'
Wkf2, GroupN1, f2, 100, '2011-01-01 01:01:01'
Wkf3, GroupN1, f2, 100, '2011-01-01 01:01:01'
Wkf4, GroupN1, f1, 100, '2011-01-01 01:01:01'
Wkf2, GroupN1, f2, 100, '2011-01-01 02:01:01'
Wkf3, GroupN1, f2, 100, '2011-01-01 04:01:01'
Wkf4, GroupN1, f1, 100, '2011-01-02 03:01:01'
Wkf2, GroupN1, f2, 100, '2011-01-02 02:01:01'
Wkf2, GroupN1, f2, 100, '2011-01-01 02:01:01'
Wkf3, GroupN1, f2, 100, '2011-01-01 02:03:01'
Wkf4, GroupN1, f1, 100, '2011-01-02 02:05:01'
Wkf2, GroupN1, f2, 100, '2011-01-02 02:01:01'
];
Found solution, when we change type to calculated and do some operation on string ( eg. extract substring ) it's starting to listen.
Found solution, when we change type to calculated and do some operation on string ( eg. extract substring ) it's starting to listen.